psql

[Carlos Ojea Castro]

Hello:

I have postgreSQL 7.4.1 installed, but I can't start psql (I was able to
start psql a few weeks ago...)
I get this message:
debian-ojea:/home/carlos# psql buques_db
/usr/lib/postgresql/bin/psql: relocation error:
/usr/local/lib/libreadline.so. 4: undefined symbol: BC

Anyone knows what is happening?
Thank you,
Carlos
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

[Vams]

On Tuesday 22 June 2004 11:11 am, Carlos Ojea Castro wrote:

I have postgreSQL 7.4.1 installed, but I can't start psql (I was able to
start psql a few weeks ago...)
I get this message:
debian-ojea:/home/carlos# psql buques_db
/usr/lib/postgresql/bin/psql: relocation error:
/usr/local/lib/libreadline.so. 4: undefined symbol: BC

You might already have postgresql preinstalled and have improperly upgrade it?
Or, you might have more than one version installed.

just shooting some possibilities,
Vams

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Carlos Ojea Castro]

Vams wrote:

On Tuesday 22 June 2004 11:11 am, Carlos Ojea Castro wrote:

I have postgreSQL 7.4.1 installed, but I can't start psql (I was able to
start psql a few weeks ago...)
I get this message:
debian-ojea:/home/carlos# psql buques_db
/usr/lib/postgresql/bin/psql: relocation error:
/usr/local/lib/libreadline.so. 4: undefined symbol: BC

You might already have postgresql preinstalled and have improperly upgrade it?
Or, you might have more than one version installed.

just shooting some possibilities,
Vams

I made 'apt-get install postgresql', but it was an old version, so I
purged it and then I compile and install 7.4.1 from source...

This is the output of 'dpkg -s postgresql':
debian-ojea:/home/carlos# dpkg -s postgresql
Package: postgresql
Status: purge ok not-installed
Priority: optional
Section: misc

But postgresql is installed:
carlos@debian-ojea:~$ /usr/local/pgsql/bin/postmaster -D
/home/carlos/programacion/compulab/buques/database/
LOG: database system was shut down at 2004-06-22 17:44:05 CEST
LOG: checkpoint record is at 0/289F6F78
LOG: redo record is at 0/289F6F78; undo record is at 0/0; shutdown TRUE
LOG: next transaction ID: 735362; next OID: 17869
LOG: database system is ready

So, do you know what can I do to correct the problem?
Thank you, regards
Carlos
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Daniel Verite]

Carlos Ojea Castro writes

/usr/lib/postgresql/bin/psql: relocation error:

The location suggests it's the psql from the postgresql-client
debian package.
debian-ojea:/home/carlos# dpkg -s postgresql
Package: postgresql
Status: purge ok not-installed
Priority: optional
Section: misc

But postgresql is installed:
carlos@debian-ojea:~$ /usr/local/pgsql/bin/postmaster -D

You probably need to purge the postgresql-client package
as well, so that your shell will find /usr/local/pgsql/bin/psql
which should be the one that you installed from source.

--
Daniel.
PostgreSQL-based mail storage and user agent:
http://sourceforge.net/projects/manitou-mail

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

[Richard Huxton]

Daniel Verite wrote:

You probably need to purge the postgresql-client package
as well, so that your shell will find /usr/local/pgsql/bin/psql
which should be the one that you installed from source.

I believe there is a "backports" repository with up-to-date versions you
can just apt-get though. Any Debianites like to go on the record as to
how to set that up?

--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

[Tom Lane]

Carlos Ojea Castro <ca********@lev eltelecom.es> writes:

I get this message:
debian-ojea:/home/carlos# psql buques_db
/usr/lib/postgresql/bin/psql: relocation error:
/usr/local/lib/libreadline.so. 4: undefined symbol: BC

I made 'apt-get install postgresql', but it was an old version, so I
purged it and then I compile and install 7.4.1 from source...

Did you upgrade readline since then? Because this sure looks like
readline's problem not ours.

The only thing I can think of is to rebuild Postgres and see if it works
better. (You might as well update to PG 7.4.3 while you're at it.)

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Carlos Ojea Castro]

Daniel Verite wrote:

Carlos Ojea Castro writes

/usr/lib/postgresql/bin/psql: relocation error:

The location suggests it's the psql from the postgresql-client
debian package.

debian-ojea:/home/carlos# dpkg -s postgresql
Package: postgresql
Status: purge ok not-installed
Priority: optional
Section: misc

But postgresql is installed:
carlos@debi an-ojea:~$ /usr/local/pgsql/bin/postmaster -D

You probably need to purge the postgresql-client package
as well, so that your shell will find /usr/local/pgsql/bin/psql
which should be the one that you installed from source.

THAT WAS IT !!!
I made 'dpkg -r postgresql-client' and then I made another install from
source.... and it works !!

Thank you very much,
Carlos

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postg resql.org so that your
message can get through to the mailing list cleanly

[Carlos Ojea Castro]

Hello:

I am trying to access a postgresql database.
I made a SQLConnection object and I got it active.
Then I made a SQLQuery object, but when I try to make it active, i get a
'access violation' message.

Am I missing something?

Regards,
Carlos

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Raymond O'Donnell]

On 29 Jun 2004 at 12:59, Carlos Ojea Castro wrote:

I am trying to access a postgresql database.
I made a SQLConnection object and I got it active.
Then I made a SQLQuery object, but when I try to make it active, i get a
'access violation' message.

Probably a silly question, but have you got a dbExpress driver for
Postgres? The only one I know is the VitaVoom (commercial) one at
www.vitavoom.com.

--Ray.

-------------------------------------------------------------
Raymond O'Donnell http://www.galwaycathedral.org/recitals
ro*@iol.ie Galway Cathedral Recitals
-------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postg resql.org

[Carlos Ojea Castro]

Raymond O'Donnell wrote:

On 29 Jun 2004 at 12:59, Carlos Ojea Castro wrote:

I am trying to access a postgresql database.
I made a SQLConnection object and I got it active.
Then I made a SQLQuery object, but when I try to make it active, i get a
'access violation' message.
Probably a silly question, but have you got a dbExpress driver for
Postgres? The only one I know is the VitaVoom (commercial) one at
www.vitavoom.com.

I use a postgresql driver, and I think that works because SQLConnection
object is active (I also made queries a few weeks ago, but I don't know
why I get this error now).

Regards,
Carlos
--Ray.

-------------------------------------------------------------
Raymond O'Donnell http://www.galwaycathedral.org/recitals
ro*@iol.ie Galway Cathedral Recitals
-------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings