BUG #15994: can't run psql
The following bug has been logged on the website:
Bug reference: 15994
Logged by: Kurt Neufeld
Email address: kneufeld@burgundywall.com
PostgreSQL version: 11.5
Operating system: Ubuntu 18.04
Description:
# psql --version
/usr/lib/postgresql/11/bin/psql: symbol lookup error:
/usr/lib/postgresql/11/bin/psql: undefined symbol: PQsslInUse
The cluster itself seems fine, pgcli can connect to it for instance.
On an Ubuntu 16.04 machine, psql 11.5-1.pgdg16.04+1 works fine.
PG Bug reporting form <noreply@postgresql.org> writes:
# psql --version
/usr/lib/postgresql/11/bin/psql: symbol lookup error:
/usr/lib/postgresql/11/bin/psql: undefined symbol: PQsslInUse
Evidently this is binding to an old version of libpq.so that lacks
that symbol. Probably it's finding some vendor-provided libpq.so
in /usr/lib or /usr/lib64, whereas what you need is to find the
one in /usr/lib/postgresql/11/lib. Applying "ldd" to the psql
executable would help confirm that diagnosis.
It's hard to say more than that without knowing anything about
how this installation was built.
regards, tom lane