-----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----- -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
