Re: Users and multiple server environment

Quoting Michael Long <mlong(at)datalong(dot)com>:

>
> ./psql template1
> ./psql: relocation error: ./psql: undefined symbol: PQsetErrorVerbosity
>
> Is psql linked to the proper libraries?
>
> --This is version 7.3.2

Below looks okay.

> ldd /usr/bin/psql
> libpq.so.3 => /usr/lib/libpq.so.3 (0x40015000)
> libpam.so.0 => /lib/libpam.so.0 (0x4003a000)
> libssl.so.0.9.6 => /usr/lib/libssl.so.0.9.6 (0x40042000)
> libcrypto.so.0.9.6 => /usr/lib/libcrypto.so.0.9.6 (0x40072000)
> libz.so.1 => /lib/libz.so.1 (0x40149000)
> libreadline.so.4 => /lib/libreadline.so.4 (0x40158000)
> libcrypt.so.1 => /lib/libcrypt.so.1 (0x40185000)
> libresolv.so.2 => /lib/libresolv.so.2 (0x401b6000)
> libnsl.so.1 => /lib/libnsl.so.1 (0x401c9000)
> libdl.so.2 => /lib/libdl.so.2 (0x401de000)
> libm.so.6 => /lib/libm.so.6 (0x401e1000)
> libc.so.6 => /lib/libc.so.6 (0x40203000)
> libncurses.so.5 => /lib/libncurses.so.5 (0x40339000)
> /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
>

I've never installed 8.0b3, but I would guess that libpq is also found in
/usr/local. Check for a second copy there and modify LD_LIBRARY_PATH and/or
/etc/ld.so.conf (followed by ldconfig) on Linux to look there first.

> ldd /usr/local/pgsql_8.0b3/bin/psql
> libpq.so.3 => /usr/lib/libpq.so.3 (0x40025000)
> libz.so.1 => /lib/libz.so.1 (0x40039000)
> libreadline.so.4 => /lib/libreadline.so.4 (0x40049000)
> libcrypt.so.1 => /lib/libcrypt.so.1 (0x40076000)
> libresolv.so.2 => /lib/libresolv.so.2 (0x400a7000)
> libnsl.so.1 => /lib/libnsl.so.1 (0x400b9000)
> libdl.so.2 => /lib/libdl.so.2 (0x400ce000)
> libm.so.6 => /lib/libm.so.6 (0x400d1000)
> libc.so.6 => /lib/libc.so.6 (0x400f4000)
> libssl.so.0.9.6 => /usr/lib/libssl.so.0.9.6 (0x4022a000)
> libcrypto.so.0.9.6 => /usr/lib/libcrypto.so.0.9.6 (0x4025a000)
> libncurses.so.5 => /lib/libncurses.so.5 (0x40331000)
> /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>

----------------------------------------------------------------
This message was sent using IMP, the Internet Messaging Program.