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

-----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 <suri(dot)hosur(at)gmail(dot)com>
To: Rafael Martinez <r(dot)m(dot)guerrero(at)usit(dot)uio(dot)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
<r(dot)m(dot)guerrero(at)usit(dot)uio(dot)no>wrote:

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

- --

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