Re: Users and multiple server environment

Michael Long <mlong(at)datalong(dot)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