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

On Wed, 2011-12-28 at 01:54 -0800, hosuresh wrote:

I have installed postgresql-9.0 on my CentOS 6.0 server in the
directory
/usr/pgsql-9.0/.
Its data directory resides in /var/lib/pgsql/9.0/

unable to run $psql dbname command

when i run the commands its showing the error like:

[root@CentOS-60-32-minimal ~]# su - postgres
-bash-4.1$ psql msdi
psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
-bash-4.1$

Are there any os-supplied RPMs? What is the output of:

rpm -qa|grep postgresql

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

This message has been digitally signed by the sender.

Hi devrim,
Thanks for the responce

when i run the command
rpm -qa | grep postgresql-9.0

Its not dispalying anything...

-----

Regards,
Suresh Hosur
--
View this message in context: http://postgresql.1045698.n5.nabble.com/psql-error-psql-symbol-lookup-error-psql-undefined-symbol-PQconnectdbParams-tp5104950p5104989.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

On Wed, 2011-12-28 at 02:30 -0800, hosuresh wrote:

when i run the command
rpm -qa | grep postgresql-9.0

Its not dispalying anything...

I did not say postgresql-9.0 -- I said

rpm -qa|grep postgresql

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz

On 12/28/11 1:54 AM, hosuresh wrote:

I have installed postgresql-9.0 on my CentOS 6.0 server in the directory
/usr/pgsql-9.0/.
Its data directory resides in /var/lib/pgsql/9.0/

unable to run $psql dbname command

when i run the commands its showing the error like:

[root@CentOS-60-32-minimal ~]# su - postgres
-bash-4.1$ psql msdi
psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
-bash-4.1$

what do you get from...

# su - postgres
$ which psql
$ psql -v

and

$ ldd $(which psql)

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

Hello Devrim,

ya when i run its dispalying like

[root@CentOS-60-32-minimal lib]# rpm -qa | grep postgresql
postgresql90-docs-9.0.6-1PGDG.rhel6.i686
postgresql84-libs-8.4.9-1PGDG.rhel6.i686
postgresql90-libs-9.0.6-1PGDG.rhel6.i686
postgresql90-contrib-9.0.6-1PGDG.rhel6.i686
postgresql90-server-9.0.6-1PGDG.rhel6.i686
postgresql90-9.0.6-1PGDG.rhel6.i686
postgresql90-devel-9.0.6-1PGDG.rhel6.i686
postgresql-libs-8.4.9-1.el6_1.1.i686

so, is it the problem with my postgres....??

-----

Regards,
Suresh Hosur
--
View this message in context: http://postgresql.1045698.n5.nabble.com/psql-error-psql-symbol-lookup-error-psql-undefined-symbol-PQconnectdbParams-tp5104950p5105189.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Hello John R Pierce,

When i run the

$su - postgres
#which psql

Its dispalying like:

[root@CentOS-60-32-minimal ]# su - postgres
-bash-4.1$ which psql
/usr/bin/psql

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)
libssl.so.10 => /usr/lib/libssl.so.10 (0x00f22000)
libreadline.so.6 => /lib/libreadline.so.6 (0x0082e000)
libc.so.6 => /lib/libc.so.6 (0x001f2000)
libcrypto.so.10 => /usr/lib/libcrypto.so.10 (0x009cf000)
libgssapi_krb5.so.2 => /lib/libgssapi_krb5.so.2 (0x0039d000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x00de2000)
libldap_r-2.4.so.2 => /lib/libldap_r-2.4.so.2 (0x00113000)
libpthread.so.0 => /lib/libpthread.so.0 (0x00e42000)
libkrb5.so.3 => /lib/libkrb5.so.3 (0x00c86000)
libcom_err.so.2 => /lib/libcom_err.so.2 (0x0046f000)
libk5crypto.so.3 => /lib/libk5crypto.so.3 (0x0092f000)
libresolv.so.2 => /lib/libresolv.so.2 (0x00e24000)
libdl.so.2 => /lib/libdl.so.2 (0x00dd2000)
libz.so.1 => /lib/libz.so.1 (0x008d7000)
libtinfo.so.5 => /lib/libtinfo.so.5 (0x00bf8000)
/lib/ld-linux.so.2 (0x00ba1000)
libkrb5support.so.0 => /lib/libkrb5support.so.0 (0x00f99000)
libkeyutils.so.1 => /lib/libkeyutils.so.1 (0x00166000)
libfreebl3.so => /usr/lib/libfreebl3.so (0x0095f000)
liblber-2.4.so.2 => /lib/liblber-2.4.so.2 (0x00be1000)
libssl3.so => /usr/lib/libssl3.so (0x0066e000)
libsmime3.so => /usr/lib/libsmime3.so (0x00169000)
libnss3.so => /usr/lib/libnss3.so (0x00473000)
libnssutil3.so => /usr/lib/libnssutil3.so (0x00194000)
libplds4.so => /lib/libplds4.so (0x00e62000)
libplc4.so => /lib/libplc4.so (0x001ae000)
libnspr4.so => /lib/libnspr4.so (0x001b3000)
libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0x00382000)
libselinux.so.1 => /lib/libselinux.so.1 (0x003db000)

is it the path problem...??

-----

Regards,
Suresh Hosur
--
View this message in context: http://postgresql.1045698.n5.nabble.com/psql-error-psql-symbol-lookup-error-psql-undefined-symbol-PQconnectdbParams-tp5104950p5105203.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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

Tanks a lot to all...

Finally i got the solution... my postgres working fine on server...

-----

Regards,
Suresh Hosur
--
View this message in context: http://postgresql.1045698.n5.nabble.com/psql-error-psql-symbol-lookup-error-psql-undefined-symbol-PQconnectdbParams-tp5104950p5107139.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.