Re: Cannot Restart PostgreSQL-8.1.4

On 1/24/07, Rich Shepard <rshepard(at)appl-ecosys(dot)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/