Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229])
	by mail.postgresql.org (Postfix) with ESMTP id E48EFF47F68
	for <pgsql-admin@postgresql.org>; Wed, 28 Dec 2011 05:57:29 -0400 (AST)
Received: from mail-out2.uio.no ([2001:700:100:10::58])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <r.m.guerrero@usit.uio.no>) id 1RfqGG-0008G3-7z
	for pgsql-admin@postgresql.org; Wed, 28 Dec 2011 09:57:29 +0000
Received: from mail-mx1.uio.no ([129.240.10.29])
	by mail-out2.uio.no with esmtp (Exim 4.75)
	(envelope-from <r.m.guerrero@usit.uio.no>)
	id 1RfqG4-0005Di-3e; Wed, 28 Dec 2011 10:57:16 +0100
Received: from 84.122.25.226.dyn.user.ono.com ([84.122.25.226]
	helo=[10.2.2.101])
	by mail-mx1.uio.no with esmtpsa (TLSv1:CAMELLIA256-SHA:256)
	user rafael (Exim 4.76) (envelope-from <r.m.guerrero@usit.uio.no>)
	id 1RfqG3-0006dr-Dl; Wed, 28 Dec 2011 10:57:16 +0100
Message-ID: <4EFAE837.1020604@usit.uio.no>
Date: Wed, 28 Dec 2011 10:58:15 +0100
From: Rafael Martinez <r.m.guerrero@usit.uio.no>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.2.24) Gecko/20111108 Thunderbird/3.1.16
MIME-Version: 1.0
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
References: 
 <CAHbdBsJX-oD_C3HZAyHs19asYeFGck-CsEJWKUrN3g52JT17vw@mail.gmail.com>
In-Reply-To: 
 <CAHbdBsJX-oD_C3HZAyHs19asYeFGck-CsEJWKUrN3g52JT17vw@mail.gmail.com>
X-Enigmail-Version: 1.1.2
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-UiO-Ratelimit-Test: rcpts/h 2 msgs/h 1 sum rcpts/h 2 sum msgs/h 1 total
	rcpts 3455 max rcpts/h 19 ratelimit 0
X-UiO-Spam-info: not spam, SpamAssassin (score=-7.0, required=5.0,
	autolearn=disabled, MISSING_FROM=1, TVD_RCVD_IP=0.001,
	UIO_MAIL_IS_INTERNAL=-5, UIO_PGP_SIGNED=-3, uiobl=NO, uiouri=NO)
X-UiO-Scanned: 3533BE60A4FB6A0DE4DB70F0423B2227FE131E5C
X-UiO-SPAM-Test: remote_host: 84.122.25.226 spam_score: -69 maxlevel 80
	minaction 2 bait 0 mail/h: 1 total 177 max/h 4 blacklist 0
	greylist 0 ratelimit 0
X-Pg-Spam-Score: -3.2 (---)
X-Archive-Number: 201112/145
X-Sequence-Number: 38903

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