Thread: psql error on postgresql-9.0 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
psql error on postgresql-9.0 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
From
Suresh Hosur
Date:
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
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
Re: psql error on postgresql-9.0 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
From
Rafael Martinez
Date:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 12/28/2011 10:44 AM, Suresh Hosur wrote: > 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$ > Hello Most probably your installation of postgres is using a version of libpq.so already installed in your system and not compatible with postgresql-9.0. You haven't said how you installed postgres under /usr/pgsql-9.0/ in your system, from source? Check your PATH variable for the user postgres. Which installation you are using (type psql) and which libpq your executables are trying to use (ldd /path_to_executable/psql). You can either delete the libpq installed in your system and use the one you have installed under /usr/pgsql-9.0/, or upgrade the libpq in your system to a version compatible with what you have installed under /usr/pgsql-9.0/. regards, - -- Rafael Martinez Guerrero Center for Information Technology University of Oslo, Norway PGP Public Key: http://folk.uio.no/rafael/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk766DAACgkQBhuKQurGihSwwQCghznW0NKA1jUUXJi4W47qaYn5 nGAAmQFyhoOARs0FHtO2ZEJJ9ZewkjGN =gEpd -----END PGP SIGNATURE-----