Test connection to postgres with SSL with the command line

Question

I need to test a connection to a distant postgres database with SSL turned on, and be notified of the result. I have the following command:

psql "sslmode=verify-ca sslrootcert=myRootCert.crt sslcert=myPublicCert.crt sslkey=myPrivateKey.key hostaddr=host user=user port=port dbname=db password=passwd"

It works fine, I am logged in and I can start typing commands. But what I need is only the status of the connection test, I don't want to be logged in after.

I saw there is a pg_isready command, but I can not find how to use it with SSL.

Laurenz Albe · Accepted Answer · 2022-05-12 10:35:56Z

3

You can use your connection string like this:

pg_isready -d 'sslmode=verify-ca sslrootcert=myRootCert.crt sslcert=myPublicCert.crt sslkey=myPrivateKey.key hostaddr=host user=user port=port dbname=db password=passwd'

answered May 12, 2022 at 10:35

Laurenz Albe

257k22 gold badges313 silver badges389 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Test connection to postgres with SSL with the command line

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related