How to resolve "psql: symbol lookup error: psql: undefined symbol: PQencryptPasswordConn, version RHPG_10"
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.