Thread: 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