Re: psql: relocation error: psql: undefined

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