============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Ralf Burger
Your email address : Ralf@burger-AG.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