Re: psql error
| От | Azimuddin Mohammed |
|---|---|
| Тема | Re: psql error |
| Дата | |
| Msg-id | CAKUuFd7oWU=4aA642mBkiBgiSOpZbGKEdeO1JbdjfVWhqwWekg@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: psql error (Tom Lane <tgl@sss.pgh.pa.us>) |
| Ответы |
Re: psql error
(Tom Lane <tgl@sss.pgh.pa.us>)
|
| Список | 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 по дате отправления: