-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 - -------- Original Message -------- Subject: Re: 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@xxxxxxxxx> To: Rafael Martinez <r.m.guerrero@xxxxxxxxxxx> 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@xxxxxxxxxxx>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----- -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
