Обсуждение: psql error
psql: symbol lookup error: psql: undefined symbol: PQconnectdbParams
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
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
Azimuddin Mohammed <azimeiu@gmail.com> writes:
> You are right, current postgres version installed is 9.4 and below is the
> output for ldd. Is there a way I can fix this ?
I don't see libpq.so in that list at all. Maybe you don't have it
installed, or it's not in the loader search path?
regards, tom lane
Azimuddin Mohammed <azimeiu@gmail.com> writes:
> You are right, current postgres version installed is 9.4 and below is the
> output for ldd. Is there a way I can fix this ?
I don't see libpq.so in that list at all. Maybe you don't have it
installed, or it's not in the loader search path?
regards, tom lane
Azimuddin Mohammed <azimeiu@gmail.com> writes:
> You are right, current postgres version installed is 9.4 and below is the
> output for ldd. Is there a way I can fix this ?
I don't see libpq.so in that list at all. Maybe you don't have it
installed, or it's not in the loader search path?
regards, tom lane
dbx postgres wrote: > How can I get all libs required for 9.4 version without loosing data? That depends a lot on your operating system, the way you installed PostgreSQL, what exactly you installed where, and so on - details you didn't care to tell us. Yours, Laurenz Albe
dbx postgres wrote:
> How can I get all libs required for 9.4 version without loosing data?
That depends a lot on your operating system, the way you installed PostgreSQL,
what exactly you installed where, and so on - details you didn't care to tell us.
Yours,
Laurenz Albe
dbx postgres wrote: > > > How can I get all libs required for 9.4 version without loosing data? > > > > That depends a lot on your operating system, the way you installed PostgreSQL, > > what exactly you installed where, and so on - details you didn't care to tell us. > > I did not say bcoz I did not installed it :-) What I know is it was upgraded from > 8.4 to 9.4 with all default directory(s). Then it might be a good idea to hire somebody with a basic knowledge of the operating system you are on, who could fix the problem for you. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com