From: Rafael Martinez <r.m.guerrero@usit.uio.no>
To: Suresh Hosur <suri.hosur@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: psql error on postgresql-9.0 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
Date: Wed, 28 Dec 2011 10:58:15 +0100
Message-ID: <4EFAE837.1020604@usit.uio.no> (raw)
In-Reply-To: <CAHbdBsJX-oD_C3HZAyHs19asYeFGck-CsEJWKUrN3g52JT17vw@mail.gmail.com>
References: <CAHbdBsJX-oD_C3HZAyHs19asYeFGck-CsEJWKUrN3g52JT17vw@mail.gmail.com>
-----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-----
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: r.m.guerrero@usit.uio.no, suri.hosur@gmail.com
Subject: Re: psql error on postgresql-9.0 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
In-Reply-To: <4EFAE837.1020604@usit.uio.no>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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