Thread: bug-report-template

bug-report-template

From
Ralf Burger
Date:
============================================================================
                        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

Re: bug-report-template

From
Tom Lane
Date:
Ralf Burger <ralf@Burger-AG.de> writes:
> ./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

You're linking against an old (pre-8.0) libpq.  Check your ldconfig
search path.

            regards, tom lane