Re: Users and multiple server environment - Mailing list pgsql-admin

From Tom Lane
Subject Re: Users and multiple server environment
Date
Msg-id 29421.1096785225@sss.pgh.pa.us
Whole thread Raw
In response to Re: Users and multiple server environment  (Michael Long <mlong@datalong.com>)
Responses Re: Users and multiple server environment
List pgsql-admin
Michael Long <mlong@datalong.com> writes:
> Further investigation shows that I was not using the newly built psql
> binary. When attempting to use the newly built binary I get an error.
> Did I miss something during the configure/make dance. Here is what I get.

>  ./psql -U proporg
> ./psql: relocation error: ./psql: undefined symbol: PQsetErrorVerbosity

This looks like a 7.4 psql trying to use a pre-7.4 libpq.so.  You need
to take a close look at where you've installed the different libpq
generations and how this matches up to the ldconfig search path.

Personally I like to use rpath-style link specifications to ensure that
a particular psql generation will hook to the corresponding libpq
generation, regardless of any system-wide ldconfig settings.  There are
other ways to do it, but the default Linux mechanism doesn't work very
well for this :-(

            regards, tom lane

pgsql-admin by date:

Previous
From: Michael Long
Date:
Subject: Re: Users and multiple server environment
Next
From: Michael Long
Date:
Subject: Re: Users and multiple server environment