Thread: psql
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
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
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
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
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
Carlos Ojea Castro <carlosojea@leveltelecom.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
Richard Huxton writes > 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? That should be as simple as adding the following entry to the /etc/apt/sources.list file: deb http://www.backports.org/debian/ woody postgresql And then # apt-get update # apt-get install postgresql -- Daniel. PostgreSQL-based mail storage and user agent: http://sourceforge.net/projects/manitou-mail
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@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. > 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 > >
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
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 rod@iol.ie Galway Cathedral Recitals -------------------------------------------------------------
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 >rod@iol.ie Galway Cathedral Recitals >------------------------------------------------------------- > > > > >
On Tue, 29 Jun 2004 12:28:57 +0100, "Raymond O'Donnell" <rod@iol.ie> 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. Kylix has one included. vitavoom has the only windows one. What pg version? I found I needed to use an older libpq.so to stop the access violations. The 7.4 one didn't work too well with borland's aging dbxpress driver. klint. +---------------------------------------+-----------------+ : Klint Gore : "Non rhyming : : EMail : kg@kgb.une.edu.au : slang - the : : Snail : A.B.R.I. : possibilities : : Mail University of New England : are useless" : : Armidale NSW 2351 Australia : L.J.J. : : Fax : +61 2 6772 5376 : : +---------------------------------------+-----------------+