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