Re: psql: relocation error: psql: undefined symbol: - Mailing list pgsql-general

From Reece Hart
Subject Re: psql: relocation error: psql: undefined symbol:
Date
Msg-id 1074818439.4062.24.camel@tallac
Whole thread Raw
In response to psql: relocation error: psql: undefined symbol: PQgetssl  (Phil Campaigne <pcampaigne@charter.net>)
Responses Re: psql: relocation error: psql: undefined symbol:  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
On Thu, 2004-01-22 at 16:13, Phil Campaigne wrote:
psql: relocation error: psql: undefined symbol: PQgetssl

Phil-

I vaguely remember seeing a similar message when I inadvertently mismatched versions of psql and libpq. I think that the problem was psql resolving to the wrong libpq, but this is an old memory.

Some suggestions:
1) ldd psql
This will tell you which libraries are being dynamically linked. Make sure you think this what you expect.

2) check/unset your LD_LIBRARY_PATH variable.

3) I'm guessing you're on a linux box (guess per mail header), I also guess you might have an RPM-based system. If so, I'd further guess that you've recompiled postgresql AND have an rpm-installed version. rpm -e postgresql will remove the rpm version (can't remember if postgresql rpms are divided into subpackages... you might actually need postgresql-libs and postgresql-clients or some such names).

-Reece

-- 
Reece Hart, http://www.in-machina.com/~reece/, GPG:0x25EC91A0

pgsql-general by date:

Previous
From: Phil Campaigne
Date:
Subject: psql: relocation error: psql: undefined symbol: PQgetssl
Next
From: Steve Atkins
Date:
Subject: Re: embedded/"serverless" (Re: serverless postgresql)