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

Hi,

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$

from two days working on it am not getting the soultion.
I searched around the internet got some suggestion like to run below command

[root@CentOS-60-32-minimal ~]# DYLD_LIBRARY_PATH=/usr/pgsql-9.0/lib psql
psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams

once i run it, It showing the same error

so, please help me to come out from this 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-tp5104950p5104950.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

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

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 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.