Re: psql error

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(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> dbx postgres <dbx2postgres(at)gmail(dot)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