Re: psql error - Mailing list pgsql-admin
| From | Azimuddin Mohammed |
|---|---|
| Subject | Re: psql error |
| Date | |
| Msg-id | CAKUuFd7oWU=4aA642mBkiBgiSOpZbGKEdeO1JbdjfVWhqwWekg@mail.gmail.com Whole thread Raw |
| In response to | Re: psql error (Tom Lane <tgl@sss.pgh.pa.us>) |
| Responses |
Re: psql error
(Tom Lane <tgl@sss.pgh.pa.us>)
|
| List | pgsql-admin |
linux-vdso.so.1 => (0x00007fff05bef000)
libxml2.so.2 => /usr/lib64/libxml2.so.2 (0x0000003eb9a00000)
libpam.so.0 => /lib64/libpam.so.0 (0x000000390f600000)
libssl.so.10 => /usr/lib64/libssl.so.10 (0x000000390ee00000)
libcrypto.so.10 => /usr/lib64/libcrypto.so.10 (0x0000003eb7600000)
libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x000000390ea00000)
libdl.so.2 => /lib64/libdl.so.2 (0x0000003eb1200000)
libm.so.6 => /lib64/libm.so.6 (0x0000003eb1e00000)
libldap-2.4.so.2 => /lib64/libldap-2.4.so.2 (0x00000031e5000000)
libc.so.6 => /lib64/libc.so.6 (0x0000003eb0a00000)
libkrb5.so.3 => /lib64/libkrb5.so.3 (0x000000390e600000)
libcom_err.so.2 => /lib64/libcom_err.so.2 (0x000000390de00000)
libz.so.1 => /lib64/libz.so.1 (0x0000003eb1a00000)
libaudit.so.1 => /lib64/libaudit.so.1 (0x000000390d600000)
libcrypt.so.1 => /lib64/libcrypt.so.1 (0x0000003eb4e00000)
libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x0000003eb8a00000)
libresolv.so.2 => /lib64/libresolv.so.2 (0x0000003eb3200000)
libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x0000003eb9600000)
libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x0000003eb6e00000)
/lib64/ld-linux-x86-64.so.2 (0x0000003eb0600000)
liblber-2.4.so.2 => /lib64/liblber-2.4.so.2 (0x00000031e3c00000)
libsasl2.so.2 => /usr/lib64/libsasl2.so.2 (0x0000003eb8600000)
libssl3.so => /usr/lib64/libssl3.so (0x00000031e3800000)
libsmime3.so => /usr/lib64/libsmime3.so (0x00000031e3400000)
libnss3.so => /usr/lib64/libnss3.so (0x00000031e3000000)
libnssutil3.so => /usr/lib64/libnssutil3.so (0x0000003eb3600000)
libplds4.so => /lib64/libplds4.so (0x0000003eb4200000)
libplc4.so => /lib64/libplc4.so (0x0000003eb3e00000)
libnspr4.so => /lib64/libnspr4.so (0x0000003eb2e00000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x0000003eb0e00000)
libfreebl3.so => /lib64/libfreebl3.so (0x0000003eb4600000)
libselinux.so.1 => /lib64/libselinux.so.1 (0x0000003eb2200000)
librt.so.1 => /lib64/librt.so.1 (0x0000003eb1600000)
dbx postgres <dbx2postgres@gmail.com> writes:
> I have postgres running on my server but when i try to run psql I get the
> below error
> *psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams *
Apparently, you have a 9.0-or-later psql trying to use a pre-9.0 copy
of libpq.so, because that function was added in 9.0. This would seem
to mean that you have (portions of?) at least two different PG
installations, and they're not staying out of each others' way.
Hard to say more than that with only this much data.
If this is a Linux platform, applying "ldd" to the psql executable
would reveal which libpq it's trying to use.
regards, tom lane
Regards,
Azim
pgsql-admin by date: