Received: from magus.postgresql.org (magus.postgresql.org [87.238.57.229]) by mail.postgresql.org (Postfix) with ESMTP id 87B1AF47F68 for ; Wed, 28 Dec 2011 06:37:02 -0400 (AST) Received: from mail-out1.uio.no ([2001:700:100:10::57]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1RfqsX-0000cI-5S for pgsql-admin@postgresql.org; Wed, 28 Dec 2011 10:37:02 +0000 Received: from mail-mx3.uio.no ([129.240.10.44]) by mail-out1.uio.no with esmtp (Exim 4.75) (envelope-from ) id 1RfqsK-0005tz-SU for pgsql-admin@postgresql.org; Wed, 28 Dec 2011 11:36:48 +0100 Received: from 84.122.25.226.dyn.user.ono.com ([84.122.25.226] helo=[10.2.2.101]) by mail-mx3.uio.no with esmtpsa (TLSv1:CAMELLIA256-SHA:256) user rafael (Exim 4.76) (envelope-from ) id 1RfqsK-0007mN-AZ for pgsql-admin@postgresql.org; Wed, 28 Dec 2011 11:36:48 +0100 Message-ID: <4EFAF17C.5080901@usit.uio.no> Date: Wed, 28 Dec 2011 11:37:48 +0100 From: Rafael Martinez Reply-To: pgsql-admin@postgresql.org 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: pgsql-admin@postgresql.org Subject: Re: psql error on postgresql-9.0 : psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams X-Enigmail-Version: 1.1.2 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-UiO-Ratelimit-Test: rcpts/h 1 msgs/h 1 sum rcpts/h 2 sum msgs/h 1 total rcpts 3456 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: CC39928AB3B83CE2873174731762E017417C4271 X-UiO-SPAM-Test: remote_host: 84.122.25.226 spam_score: -69 maxlevel 80 minaction 2 bait 0 mail/h: 1 total 178 max/h 4 blacklist 0 greylist 0 ratelimit 0 X-Pg-Spam-Score: -3.2 (---) X-Archive-Number: 201112/147 X-Sequence-Number: 38905 -----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 To: Rafael Martinez 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 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-----