[ADMIN] psql error on postgresql-9.0 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams

[Suresh Hosur]

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:

[***@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

[***@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...

[Rafael Martinez]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Post by Suresh Hosur
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
-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-----

[Rafael Martinez]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



- -------- Original Message --------
Subject: Re: [ADMIN] psql error on postgresql-9.0 : psql: symbol lookup
error: psql: undefined symbol: PQconnectdbParams
Date: Wed, 28 Dec 2011 16:03:31 +0530
From: Suresh Hosur <***@gmail.com>
To: Rafael Martinez <***@usit.uio.no>

Hello Rafael Martinez Guerrero,

Thanks for the responce.
The file i checked its linked to libpq.so -> libpq.so.5.3
so, not getting how to come out from this proble...

On Wed, Dec 28, 2011 at 3:28 PM, Rafael Martinez

Post by Rafael Martinez

Post by Suresh Hosur
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
-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,

- --






Regards,*
*Suresh Hosur

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk768XYACgkQBhuKQurGihTCkgCfRmuWe/EWzD/54TvMkf5UdNKN
DgcAn0LX2pwwHTghO6m3lu5P50KpX5+M
=PYwo
-----END PGP SIGNATURE-----