================================================== ==========================
POSTGRESQL BUG REPORT TEMPLATE
================================================== ==========================


Your name : Ralf Burger
Your email address : Ralf (AT) burger-AG (DOT) de


System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium

Operating System (example: Linux 2.4.18) : 2.6.6

PostgreSQL version (example: PostgreSQL-8.0) : PostgreSQL-8.0 beta2

Compiler used (example: gcc 2.95.2) : 2.95.3


Please enter a FULL description of your problem:
------------------------------------------------

I am testing beta1 since about 2 weeks - it was working fine.
After an update to beta2, I was unable to start the postmaster.
So I pg_dumped it all and made a new initdb.
The postmaster is now running, but psql does not work:


../postgresql-8.0.0beta2/bin/psql template1
../postgresql-8.0.0beta2/bin/psql: error while loading shared libraries:
../postgresql-8.0.0beta2/bin/psql: undefined symbol: PQserverVersion

So I made the restore basics (database/user-creation) with psql from
beta1 and then a restore of the data.
The rest of the program seems to work. Applications are running.




Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------

the configs of beta1 and beta2 are the same.

the error only occurs, when an existing table is given:

postgres@postgres:~ > ./bin/psql
psql: FATAL: database "postgres" does not exist

postgres@postgres:~ > ./bin/psql template1
../bin/psql: error while loading shared libraries: ./bin/psql: undefined
symbol: PQserverVersion


here ist the ldd-output

../postgresql-8.0.0beta2 # ldd ./bin/psql
libpq.so.3 => /usr/local/pgsql/lib/libpq.so.3 (0x4001a000)
libz.so.1 => /usr/lib/libz.so.1 (0x40043000)
libreadline.so.4 => /usr/local/lib/libreadline.so.4 (0x40053000)
libncurses.so.5 => /usr/lib/libncurses.so.5 (0x4007a000)
libcrypt.so.1 => //lib/libcrypt.so.1 (0x400bb000)
libresolv.so.2 => //lib/libresolv.so.2 (0x400ea000)
libnsl.so.1 => //lib/libnsl.so.1 (0x400fc000)
libdl.so.2 => //lib/libdl.so.2 (0x40112000)
libm.so.6 => //lib/libm.so.6 (0x40116000)
libc.so.6 => //lib/libc.so.6 (0x40145000)
/lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x40000000)


best regards

ralf


---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Ralf Burger <ralf (AT) Burger-AG (DOT) de> writes:
You're linking against an old (pre-8.0) libpq. Check your ldconfig
search path.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings