dbTalk Databases Forums  

[BUGS] bug-report-template

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] bug-report-template in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Ralf Burger
 
Posts: n/a

Default [BUGS] bug-report-template - 09-10-2004 , 08:24 PM






================================================== ==========================
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

Reply With Quote
  #2  
Old   
Tom Lane
 
Posts: n/a

Default Re: [BUGS] bug-report-template - 09-10-2004 , 09:00 PM






Ralf Burger <ralf (AT) Burger-AG (DOT) de> writes:
Quote:
./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

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


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.