Re: psql: relocation error: psql: undefined - Mailing list pgsql-general

From Reece Hart
Subject Re: psql: relocation error: psql: undefined
Date
Msg-id 1074883706.14880.4.camel@whoville
Whole thread Raw
In response to psql: relocation error: psql: undefined symbol: PQgetssl  (Phil Campaigne <pcampaigne@charter.net>)
List pgsql-general
On Thu, 2004-01-22 at 18:00, Phil Campaigne wrote:
Thanks for your reply.  My system has Red Hat 8.0 with postgresql 
installed from it as rpm.  Then I tried to rpm -e and went to the 
postgresql-7.3.4.tar.gz distribution of source because the rpm wasn't 
yet available.

I don't see the LD_LIBRARY_PATH listed using the "env" command, and I 
can't get the command "ldd psql" to be recognized.
:+( Phil

LD_LIBRARY_PATH is often not set except for users with specific needs. Having it set might lead to your symptoms, but having it unset is almost certainly fine.

That's ldd (not lld) and you certainly have it... it's part of glibc-common which in turn is required (in the rpm sense) by glibc. Example:
whoville$ ldd `type -p psql`
        libpq.so.3 => /apps/compbio/i686-linux-2.4/opt/postgresql-7.4/lib/libpq.so.3 (0x40017000)
        libpam.so.0 => /lib/libpam.so.0 (0x40045000)
        libssl.so.2 => /lib/libssl.so.2 (0x4004d000)
        libcrypto.so.2 => /lib/libcrypto.so.2 (0x4007c000)
  (and so on)

Tip: pg_config --configure will tell you how the current installation was configured. I recompile roughly like this:

$ cd postgresql-7.4.1
$ pg_config --configure
'--prefix=/apps/compbio/i686-linux-2.4/opt/postgresql-7.4'  '--with-perl'  '--with-python'  '--with-tcl' '--with-CXX'  '--with-openssl'  '--with-pam'  '--with-krb5=/usr/kerberos'
$ ./configure <copy/paste above line, changing --prefix directory>
$ make
$ make install

The --prefix bit is there because I like to keep several versions around.

-Reece


-- 
Reece Hart, http://www.in-machina.com/~reece/, GPG:0x25EC91A0 0xD178AAF9

pgsql-general by date:

Previous
From: "Lee Harr"
Date:
Subject: Re: sequence in schema -- broken default
Next
From: "Joshua D. Drake"
Date:
Subject: Re: sequence in schema -- broken default