Re: Users and multiple server environment - Mailing list pgsql-admin

From dan@kwasar.biz
Subject Re: Users and multiple server environment
Date
Msg-id 1096838302.41606c9eee381@webmail.kwasar.biz
Whole thread Raw
In response to Re: Users and multiple server environment  (Michael Long <mlong@datalong.com>)
List pgsql-admin
Quoting Michael Long <mlong@datalong.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@postgresql.org so that your
>       message can get through to the mailing list cleanly
>




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

pgsql-admin by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: [HACKERS] slow count() was: tsearch2 poor performance
Next
From: Tom Lane
Date:
Subject: Re: Users and multiple server environment