libpq.so.5: no version information available

Issues related to applications and software problems and general support
Post Reply
rogerjbos
Posts: 5
Joined: 2021/06/23 15:23:00

libpq.so.5: no version information available

Post by rogerjbos » 2021/06/23 15:40:18

All, I am getting the dreaded error message libpq.so.5: no version information available for postgresql.

```
[bosr ~]$ psql --version
psql: /lib64/libpq.so.5: no version information available (required by psql)
psql: /lib64/libpq.so.5: no version information available (required by psql)
psql (PostgreSQL) 10.6
```

I don't care what version, I just need to get a working version running for another software that depends on it. I trying removing and re-install libpq, but that didn't fix the issue. Does anyone have any suggestions?

User avatar
TrevorH
Site Admin
Posts: 33191
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: libpq.so.5: no version information available

Post by TrevorH » 2021/06/23 17:24:41

What is the output from rpm -Va libpq ? And which postgresql module do you have enabled (dnf module list postgresql) ?
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke

rogerjbos
Posts: 5
Joined: 2021/06/23 15:23:00

Re: libpq.so.5: no version information available

Post by rogerjbos » 2021/06/23 17:37:04

Thanks for your reply. For some reason, I don't get any output when I run `rpm -Va libpq`

```
[bosr etc]$ rpm -Va libpq
```

I looks like I have two versions enabled.

```
[bosr etc]$ dnf module list postgresql
Last metadata expiration check: 23:46:02 ago on Tue 22 Jun 2021 01:48:04 PM EDT.
CentOS-8 - AppStream
Name Stream Profiles Summary
postgresql 9.6 [x] client, server [d] PostgreSQL server and client module
postgresql 10 [d][x] client, server [d] PostgreSQL server and client module
```
Should I disable 9.6? Thanks in advance.

User avatar
TrevorH
Site Admin
Posts: 33191
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: libpq.so.5: no version information available

Post by TrevorH » 2021/06/23 18:10:21

No output from rpm -Va means that all files match the expected checksums and is correct.

Both those modules are disabled according to the [x] next to them and 10 is [d] default. What about the lines for 12 and 13?
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke

rogerjbos
Posts: 5
Joined: 2021/06/23 15:23:00

Re: libpq.so.5: no version information available

Post by rogerjbos » 2021/06/23 18:39:16

Thanks for sticking with me. I did notice they were both disabled and did a `sudo dnf install @postgresql:10` to correct, which I think worked based on this new output:

```
[bosr ~]$ dnf module list postgresql
Last metadata expiration check: 1 day, 0:45:49 ago on Tue 22 Jun 2021 01:48:04 PM EDT.
CentOS-8 - AppStream
Name Stream Profiles Summary
postgresql 9.6 client, server [d] PostgreSQL server and client module
postgresql 10 [d][e] client, server [d] PostgreSQL server and client module

Hint: [d]efault, [e]nabled, [x]disabled, nstalled
[bosr ~]$
```
I don't have any lines for 12 or 13. I did install 13 yesterday to try to fix the issue, but removed it this morning to try to concentrate on getting 10 working.

I still get same error:

```
[bosr ~]$ psql --version
psql: /usr/pgsql-10/lib/libpq.so.5: no version information available (required by psql)
psql: /usr/pgsql-10/lib/libpq.so.5: no version information available (required by psql)
psql (PostgreSQL) 10.6
[bosr ~]$
```

User avatar
TrevorH
Site Admin
Posts: 33191
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: libpq.so.5: no version information available

Post by TrevorH » 2021/06/24 14:11:22

From what I can gather from a quick search, that message means you have mismatched versions of the psql command and the library(ies) it's trying to use. I'd suggest rpm -qf $(which psql) to id what package supplies your psql command and then making sure that all other postgres* packages are the same version as that.
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke

rogerjbos
Posts: 5
Joined: 2021/06/23 15:23:00

Re: libpq.so.5: no version information available

Post by rogerjbos » 2021/06/24 19:38:49

Thanks @trevorh for all the suggestions. That is my understanding of the error message as well. As best I could, I tried to do a full uninstall of all version of postgresql and then install version 10 and only version 10. I am stumped here.

```
[bosr ~]$ rpm -qf $(which psql)
postgresql-10.6-1.module_el8.0.0+15+f57f353b.x86_64
```

User avatar
TrevorH
Site Admin
Posts: 33191
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: libpq.so.5: no version information available

Post by TrevorH » 2021/06/24 21:01:53

Do you get anything useful from ldd -v /usr/pgsql-10/lib/libpq.so.5 ?
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke

rogerjbos
Posts: 5
Joined: 2021/06/23 15:23:00

Re: libpq.so.5: no version information available

Post by rogerjbos » 2021/07/01 23:16:24

The output is below. I don't know enough about linux to interpret it. :oops: Currently I am trying to get the IT department to re-image the server so i can start from scratch.

```
[bosr ONJob]$ ldd -v /usr/pgsql-10/lib/libpq.so.5
linux-vdso.so.1 (0x00007ffedb5da000)
libssl.so.1.1 => /lib64/libssl.so.1.1 (0x00007fb20452f000)
libcrypto.so.1.1 => /lib64/libcrypto.so.1.1 (0x00007fb204051000)
libgssapi_krb5.so.2 => /lib64/libgssapi_krb5.so.2 (0x00007fb203e01000)
libldap_r-2.4.so.2 => /lib64/libldap_r-2.4.so.2 (0x00007fb203bab000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fb20398b000)
libc.so.6 => /lib64/libc.so.6 (0x00007fb2035c8000)
libz.so.1 => /lib64/libz.so.1 (0x00007fb2033b1000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007fb2031ad000)
libkrb5.so.3 => /lib64/libkrb5.so.3 (0x00007fb202ebd000)
libk5crypto.so.3 => /lib64/libk5crypto.so.3 (0x00007fb202ca1000)
libcom_err.so.2 => /lib64/libcom_err.so.2 (0x00007fb202a9d000)
libkrb5support.so.0 => /lib64/libkrb5support.so.0 (0x00007fb20288c000)
libkeyutils.so.1 => /lib64/libkeyutils.so.1 (0x00007fb202688000)
libresolv.so.2 => /lib64/libresolv.so.2 (0x00007fb202471000)
liblber-2.4.so.2 => /lib64/liblber-2.4.so.2 (0x00007fb202261000)
libsasl2.so.3 => /lib64/libsasl2.so.3 (0x00007fb202043000)
/lib64/ld-linux-x86-64.so.2 (0x00007fb204a0d000)
libselinux.so.1 => /lib64/libselinux.so.1 (0x00007fb201e18000)
libcrypt.so.1 => /lib64/libcrypt.so.1 (0x00007fb201bef000)
libpcre2-8.so.0 => /lib64/libpcre2-8.so.0 (0x00007fb20196b000)

Version information:
/usr/pgsql-10/lib/libpq.so.5:
libgssapi_krb5.so.2 (gssapi_krb5_2_MIT) => /lib64/libgssapi_krb5.so.2
libpthread.so.0 (GLIBC_2.2.5) => /lib64/libpthread.so.0
libc.so.6 (GLIBC_2.14) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
libssl.so.1.1 (OPENSSL_1_1_0) => /lib64/libssl.so.1.1
libcrypto.so.1.1 (OPENSSL_1_1_0) => /lib64/libcrypto.so.1.1
/lib64/libssl.so.1.1:
libpthread.so.0 (GLIBC_2.2.5) => /lib64/libpthread.so.0
libc.so.6 (GLIBC_2.14) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.17) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
libcrypto.so.1.1 (OPENSSL_1_1_0d) => /lib64/libcrypto.so.1.1
libcrypto.so.1.1 (OPENSSL_1_1_0i) => /lib64/libcrypto.so.1.1
libcrypto.so.1.1 (OPENSSL_1_1_0f) => /lib64/libcrypto.so.1.1
libcrypto.so.1.1 (OPENSSL_1_1_1) => /lib64/libcrypto.so.1.1
libcrypto.so.1.1 (OPENSSL_1_1_0) => /lib64/libcrypto.so.1.1
/lib64/libcrypto.so.1.1:
libdl.so.2 (GLIBC_2.2.5) => /lib64/libdl.so.2
libpthread.so.0 (GLIBC_2.2.5) => /lib64/libpthread.so.0
libc.so.6 (GLIBC_2.14) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3.2) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.7) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.17) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.16) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
/lib64/libgssapi_krb5.so.2:
libc.so.6 (GLIBC_2.14) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.27) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.8) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
libkrb5support.so.0 (krb5support_0_MIT) => /lib64/libkrb5support.so.0
libk5crypto.so.3 (k5crypto_3_MIT) => /lib64/libk5crypto.so.3
libkrb5.so.3 (krb5_3_MIT) => /lib64/libkrb5.so.3
/lib64/libldap_r-2.4.so.2:
libresolv.so.2 (GLIBC_2.2.5) => /lib64/libresolv.so.2
libc.so.6 (GLIBC_2.14) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.12) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
libpthread.so.0 (GLIBC_2.3.2) => /lib64/libpthread.so.0
libpthread.so.0 (GLIBC_2.2.5) => /lib64/libpthread.so.0
libssl.so.1.1 (OPENSSL_1_1_0) => /lib64/libssl.so.1.1
libcrypto.so.1.1 (OPENSSL_1_1_0) => /lib64/libcrypto.so.1.1
/lib64/libpthread.so.0:
ld-linux-x86-64.so.2 (GLIBC_2.2.5) => /lib64/ld-linux-x86-64.so.2
ld-linux-x86-64.so.2 (GLIBC_PRIVATE) => /lib64/ld-linux-x86-64.so.2
libc.so.6 (GLIBC_2.14) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3.2) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
libc.so.6 (GLIBC_PRIVATE) => /lib64/libc.so.6
/lib64/libc.so.6:
ld-linux-x86-64.so.2 (GLIBC_2.3) => /lib64/ld-linux-x86-64.so.2
ld-linux-x86-64.so.2 (GLIBC_PRIVATE) => /lib64/ld-linux-x86-64.so.2
/lib64/libz.so.1:
libc.so.6 (GLIBC_2.14) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3.4) => /lib64/libc.so.6
/lib64/libdl.so.2:
ld-linux-x86-64.so.2 (GLIBC_PRIVATE) => /lib64/ld-linux-x86-64.so.2
libc.so.6 (GLIBC_PRIVATE) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
/lib64/libkrb5.so.3:
libkeyutils.so.1 (KEYUTILS_1.0) => /lib64/libkeyutils.so.1
libkeyutils.so.1 (KEYUTILS_1.5) => /lib64/libkeyutils.so.1
libkeyutils.so.1 (KEYUTILS_0.3) => /lib64/libkeyutils.so.1
libresolv.so.2 (GLIBC_2.2.5) => /lib64/libresolv.so.2
libkrb5support.so.0 (krb5support_0_MIT) => /lib64/libkrb5support.so.0
libc.so.6 (GLIBC_2.14) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.8) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.16) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
libk5crypto.so.3 (k5crypto_3_MIT) => /lib64/libk5crypto.so.3
/lib64/libk5crypto.so.3:
libkrb5support.so.0 (krb5support_0_MIT) => /lib64/libkrb5support.so.0
libc.so.6 (GLIBC_2.14) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
libcrypto.so.1.1 (OPENSSL_1_1_0) => /lib64/libcrypto.so.1.1
/lib64/libcom_err.so.2:
ld-linux-x86-64.so.2 (GLIBC_2.3) => /lib64/ld-linux-x86-64.so.2
libpthread.so.0 (GLIBC_2.2.5) => /lib64/libpthread.so.0
libc.so.6 (GLIBC_2.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.17) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
/lib64/libkrb5support.so.0:
libdl.so.2 (GLIBC_2.2.5) => /lib64/libdl.so.2
libc.so.6 (GLIBC_2.7) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.14) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.8) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
/lib64/libkeyutils.so.1:
libc.so.6 (GLIBC_2.3.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.7) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.14) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
/lib64/libresolv.so.2:
libc.so.6 (GLIBC_2.14) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_PRIVATE) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3) => /lib64/libc.so.6
/lib64/liblber-2.4.so.2:
libc.so.6 (GLIBC_2.3) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.14) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
/lib64/libsasl2.so.3:
libdl.so.2 (GLIBC_2.2.5) => /lib64/libdl.so.2
libc.so.6 (GLIBC_2.3) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.14) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.15) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3.4) => /lib64/libc.so.6
/lib64/libselinux.so.1:
libdl.so.2 (GLIBC_2.2.5) => /lib64/libdl.so.2
ld-linux-x86-64.so.2 (GLIBC_2.3) => /lib64/ld-linux-x86-64.so.2
libc.so.6 (GLIBC_2.14) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.8) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.7) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3.4) => /lib64/libc.so.6
/lib64/libcrypt.so.1:
libc.so.6 (GLIBC_2.14) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.25) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3.4) => /lib64/libc.so.6
/lib64/libpcre2-8.so.0:
libpthread.so.0 (GLIBC_2.2.5) => /lib64/libpthread.so.0
libc.so.6 (GLIBC_2.14) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.4) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.2.5) => /lib64/libc.so.6
libc.so.6 (GLIBC_2.3) => /lib64/libc.so.6
```

grubio
Posts: 1
Joined: 2022/06/23 07:18:49

Re: libpq.so.5: no version information available

Post by grubio » 2022/06/23 07:24:54

Hey, I just came across this thread as I was having the same issue. In my case, the problem was that some packages were installed from the Postgres RPM repo while others were coming from the RedHat stream.

I solved it by disabling RedHat's app stream (first remove any package installed from that stream) then:
```
sudo dnf module -qy disable postgresql
```
And then making sure the Postgres RPM repository was configured in my machine:
```
dnf install https://download.postgresql.org/pub/rep ... noarch.rpm
```

Finally, install whatever package you need, and make sure it's coming from the correct repo:
```
===============================================================================================================
Package Architecture Version Repository Size
===============================================================================================================
Installing:
postgresql10 x86_64 10.21-1PGDG.rhel8 pgdg10 1.7 M

Transaction Summary
===============================================================================================================

```

Post Reply