Re: psql error on postgresql-9.0 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams

-----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(at)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-----