pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpsql error on postgresql-9.0 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
3+ messages / 2 participants
[nested] [flat]
* psql error on postgresql-9.0 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
@ 2011-12-28 09:44 Suresh Hosur <suri.hosur@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Suresh Hosur @ 2011-12-28 09:44 UTC (permalink / raw)
To: pgsql-admin
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$
from two days working on it am not getting the soultion.
I searched around the internet got some suggestion like to run below command
[root@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...
--
Regards,*
*Suresh Hosur
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: psql error on postgresql-9.0 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
@ 2011-12-28 09:58 Rafael Martinez <r.m.guerrero@usit.uio.no>
parent: Suresh Hosur <suri.hosur@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: Rafael Martinez @ 2011-12-28 09:58 UTC (permalink / raw)
To: Suresh Hosur <suri.hosur@gmail.com>; +Cc: 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@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-----
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: psql error on postgresql-9.0 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
@ 2011-12-28 10:37 Rafael Martinez <r.m.guerrero@usit.uio.no>
0 siblings, 0 replies; 3+ messages in thread
From: Rafael Martinez @ 2011-12-28 10:37 UTC (permalink / raw)
To: pgsql-admin
-----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-----
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2011-12-28 10:37 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2011-12-28 09:44 psql error on postgresql-9.0 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams Suresh Hosur <suri.hosur@gmail.com>
2011-12-28 09:58 ` Rafael Martinez <r.m.guerrero@usit.uio.no>
2011-12-28 10:37 Re: psql error on postgresql-9.0 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams Rafael Martinez <r.m.guerrero@usit.uio.no>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox