Обсуждение: psql error: psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
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$ from two days working on it am not getting the soultion. I searched around the internet got some suggestion like to run below command [root@CentOS-60-32-minimal ~]# DYLD_LIBRARY_PATH=/usr/pgsql-9.0/lib psql psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams once i run it, It showing the same error so, please help me to come out from this problem... Regards, Suresh Hosur -- View this message in context: http://postgresql.1045698.n5.nabble.com/psql-error-psql-symbol-lookup-error-psql-undefined-symbol-PQconnectdbParams-tp5104950p5104950.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
Re: psql error: psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
От
Devrim GÜNDÜZ
Дата:
On Wed, 2011-12-28 at 01:54 -0800, hosuresh wrote: > > 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$ Are there any os-supplied RPMs? What is the output of: rpm -qa|grep postgresql Regards, -- Devrim GÜNDÜZ Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz
Вложения
Re: psql error: psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
От
John R Pierce
Дата:
On 12/28/11 1:54 AM, hosuresh wrote:
> 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$
what do you get from...
# su - postgres
$ which psql
$ psql -v
and
$ ldd $(which psql)
--
john r pierce N 37, W 122
santa cruz ca mid-left coast
Hello John R Pierce,
When i run the
$su - postgres
#which psql
Its dispalying like:
[root@CentOS-60-32-minimal ]# su - postgres
-bash-4.1$ which psql
/usr/bin/psql
and for $ ldd $(which psql) command it displaying like
-bash-4.1$ ldd $(which psql)
linux-gate.so.1 => (0x00112000)
libpq.so.5 => /usr/lib/libpq.so.5 (0x005b5000)
libssl.so.10 => /usr/lib/libssl.so.10 (0x00f22000)
libreadline.so.6 => /lib/libreadline.so.6 (0x0082e000)
libc.so.6 => /lib/libc.so.6 (0x001f2000)
libcrypto.so.10 => /usr/lib/libcrypto.so.10 (0x009cf000)
libgssapi_krb5.so.2 => /lib/libgssapi_krb5.so.2 (0x0039d000)
libcrypt.so.1 => /lib/libcrypt.so.1 (0x00de2000)
libldap_r-2.4.so.2 => /lib/libldap_r-2.4.so.2 (0x00113000)
libpthread.so.0 => /lib/libpthread.so.0 (0x00e42000)
libkrb5.so.3 => /lib/libkrb5.so.3 (0x00c86000)
libcom_err.so.2 => /lib/libcom_err.so.2 (0x0046f000)
libk5crypto.so.3 => /lib/libk5crypto.so.3 (0x0092f000)
libresolv.so.2 => /lib/libresolv.so.2 (0x00e24000)
libdl.so.2 => /lib/libdl.so.2 (0x00dd2000)
libz.so.1 => /lib/libz.so.1 (0x008d7000)
libtinfo.so.5 => /lib/libtinfo.so.5 (0x00bf8000)
/lib/ld-linux.so.2 (0x00ba1000)
libkrb5support.so.0 => /lib/libkrb5support.so.0 (0x00f99000)
libkeyutils.so.1 => /lib/libkeyutils.so.1 (0x00166000)
libfreebl3.so => /usr/lib/libfreebl3.so (0x0095f000)
liblber-2.4.so.2 => /lib/liblber-2.4.so.2 (0x00be1000)
libssl3.so => /usr/lib/libssl3.so (0x0066e000)
libsmime3.so => /usr/lib/libsmime3.so (0x00169000)
libnss3.so => /usr/lib/libnss3.so (0x00473000)
libnssutil3.so => /usr/lib/libnssutil3.so (0x00194000)
libplds4.so => /lib/libplds4.so (0x00e62000)
libplc4.so => /lib/libplc4.so (0x001ae000)
libnspr4.so => /lib/libnspr4.so (0x001b3000)
libsasl2.so.2 => /usr/lib/libsasl2.so.2 (0x00382000)
libselinux.so.1 => /lib/libselinux.so.1 (0x003db000)
is it the path problem...??
-----
Regards,
Suresh Hosur
--
View this message in context:
http://postgresql.1045698.n5.nabble.com/psql-error-psql-symbol-lookup-error-psql-undefined-symbol-PQconnectdbParams-tp5104950p5105203.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
hosuresh <suri.hosur@gmail.com> writes:
> and for $ ldd $(which psql) command it displaying like
> -bash-4.1$ ldd $(which psql)
> linux-gate.so.1 => (0x00112000)
> libpq.so.5 => /usr/lib/libpq.so.5 (0x005b5000)
Yeah, so it's linking to the libpq in /usr/lib, which is presumably the
one supplied by the Red-Hat-provided
postgresql-libs-8.4.9-1.el6_1.1.i686 package, which is not going to have
PQconnectdbParams because that was added in 9.0.
You could try removing the postgresql-libs-8.4.9-1.el6_1.1.i686 RPM,
but the odds are that isn't going to work because of other packages
depending on it (in which case forcing the removal would be a bad idea).
And I'm not convinced that would fix the problem anyway.
I think you could make it work by setting LD_LIBRARY_PATH (not
DYLD_LIBRARY_PATH, that's a Mac OS X ism) when running the 9.0 psql.
I'm surprised though that Devrim hasn't put in an rpath setting to make
that happen automatically.
regards, tom lane
Tanks a lot to all... Finally i got the solution... my postgres working fine on server... ----- Regards, Suresh Hosur -- View this message in context: http://postgresql.1045698.n5.nabble.com/psql-error-psql-symbol-lookup-error-psql-undefined-symbol-PQconnectdbParams-tp5104950p5107139.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.