How to resolve "psql: symbol lookup error: psql: undefined symbol: PQencryptPasswordConn, version RHPG_10"

Solution Verified - Updated -

Issue

  • When logging into a remote postgresql server using psql, the following error occurred:
# psql -U user1 -d DB1 -h xx.xx.xx.xx -p 5432 -c "show all"

psql: /usr/pgsql-9.6/lib/libpq.so.5: no version information available (required by psql)
psql: /usr/pgsql-9.6/lib/libpq.so.5: no version information available (required by psql)
psql: symbol lookup error: psql: undefined symbol: PQencryptPasswordConn, version RHPG_10

Environment

  • Red Hat Enterprise Linux
  • PostgreSQL

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content