-----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.hosur@gmail.com>
To: Rafael Martinez <r.m.guerrero@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
<r.m.guerrero@usit.uio.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@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-----