Re: Re: psql error: psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams

hosuresh <suri.hosur@gmail.com> writes:
> and for $ ldd $(which psql) command it displaying like

>         -bash-4.1$ ldd $(which psql)
>         linux-gate.so.1 =>  (0x00112000)
>         libpq.so.5 => /usr/lib/libpq.so.5 (0x005b5000)

Yeah, so it's linking to the libpq in /usr/lib, which is presumably the
one supplied by the Red-Hat-provided
postgresql-libs-8.4.9-1.el6_1.1.i686 package, which is not going to have
PQconnectdbParams because that was added in 9.0.

You could try removing the postgresql-libs-8.4.9-1.el6_1.1.i686 RPM,
but the odds are that isn't going to work because of other packages
depending on it (in which case forcing the removal would be a bad idea).
And I'm not convinced that would fix the problem anyway.

I think you could make it work by setting LD_LIBRARY_PATH (not
DYLD_LIBRARY_PATH, that's a Mac OS X ism) when running the 9.0 psql.
I'm surprised though that Devrim hasn't put in an rpath setting to make
that happen automatically.

            regards, tom lane