Re: psql error

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 ?

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)



On Wed, Mar 21, 2018 at 2:06 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
dbx postgres <dbx2postgres@xxxxxxxxx> 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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux