Re: Cannot Restart PostgreSQL-8.1.4 - Mailing list pgsql-general

From Chad Wagner
Subject Re: Cannot Restart PostgreSQL-8.1.4
Date
Msg-id 81961ff50701241536t3fc506d6ufc5be3275d40662@mail.gmail.com
Whole thread Raw
In response to Re: Cannot Restart PostgreSQL-8.1.4  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
On 1/24/07, Rich Shepard <rshepard@appl-ecosys.com> wrote:
         libpq.so.3 => /usr/lib/libpq.so.3 (0xb7f5f000)

So it's finding all the libraries it wants, and it's using the older
libpq.so. Interesting.

Where is your other installation of PostgreSQL installed?  I suspect this is because somewhere along the line you had a partial installation of PostgreSQL (newer pg_config, but missing libpq.so.4)


[Wed Jan 24 15:01:20 2007] [error] [client 127.0.0.1] Premature end of
script headers: /usr/local/sql-ledger/login.pl
/usr/local/sql-ledger/login.pl: symbol lookup error:
/usr/lib/perl5/site_perl/5.8.8/i486-linux/auto/DBD/Pg/Pg.so: undefined symbol: PQserverVersion

   The version of DBD::Pg is 1.4.9 which is the most recent one available.

The reason is when DBD::Pg probed the PostgreSQL configuration using pg_config --version it received a response of at least 8.0.0 or later.  Yet when it attempted to link it could only find libpq.so.3.  I would try rebuilding DBD::Pg, and run "make test" to verify whether it works before installing.

I don't know what the rules are for ld to locate libraries and link them, but perhaps if ldconfig was not run and libpq.so.4 didn't link to the right version it used libpq.so.3.

--
Chad
http://www.postgresqlforums.com/

pgsql-general by date:

Previous
From: "pankaj_wolfhunter@yahoo.co.in"
Date:
Subject: NETEZZA cursors, anyone?
Next
From: "David Lee Lambert"
Date:
Subject: Re: Questions about horizontal partitioning