Postgres Pro
Downloads
Home   >   mailing lists

Re: SSL Connection String - Mailing list pgsql-admin

From tiamoh m
Subject Re: SSL Connection String
Date
Msg-id CAPsGGUrsqaBrZ9UTvCsPfW3aGFQbVnx6zuFNrR9n=UO2YonoKQ@mail.gmail.com
Whole thread Raw
In response to Re: SSL Connection String  (Erik Wienhold <ewie@ewie.name>)
List pgsql-admin
Tree view
Thank you Erik.

On Wed, Sep 18, 2024 at 1:53 PM Erik Wienhold <ewie@ewie.name> wrote:
On 2024-09-18 17:08 +0200, tiamoh m wrote:
> I wish to find out the connection string to only establish ssl connection
> after it is set up.

Use sslmode=require (or verify-ca/verify-full if necessary) for that:
https://www.postgresql.org/docs/current/libpq-ssl.html#LIBPQ-SSL-SSLMODE-STATEMENTS

--
Erik

pgsql-admin by date:

Previous
From: Erik Wienhold
Date:
Subject: Re: SSL Connection String
Next
From: Asad Ali
Date:
Subject: Re: Automatic failback