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