BUG #15994: can't run psql

Previous Topic Next Topic
 
classic Classic list List threaded Threaded
2 messages Options
Reply | Threaded
Open this post in threaded view
|

BUG #15994: can't run psql

PG Doc comments form
The following bug has been logged on the website:

Bug reference:      15994
Logged by:          Kurt Neufeld
Email address:      [hidden email]
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.

Reply | Threaded
Open this post in threaded view
|

Re: BUG #15994: can't run psql

Tom Lane-2
PG Bug reporting form <[hidden email]> 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