Skip site navigation (1) Skip section navigation (2)

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

From: Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>
To: Suresh Hosur <suri(dot)hosur(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: psql error on postgresql-9.0 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
Date: 2011-12-28 09:58:15
Message-ID: 4EFAE837.1020604@usit.uio.no (view raw or flat)
Thread:
Lists: pgsql-admin
-----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-----

In response to

pgsql-admin by date

Next:From: lst_hoe02Date: 2011-12-28 10:13:22
Subject: Re: User password encryption using a stronger hashing function?
Previous:From: Suresh HosurDate: 2011-12-28 09:44:15
Subject: psql error on postgresql-9.0 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group