Re: SSL Enablement in Postgres via Client App like PG-ADMIN-4, Java.

On 5/5/23 06:49, sujay kadam wrote:
> Hi Team.
>
> I have enabled SSL in postgres on a different port using pgbouncer.
>
> I have changed the default port to 6432 and made it SSL enabled and
> configured pgbouncer to listen port 5432 which is non-ssl.
>
> But we are connecting directly using port, not by uploading a
> certificate or setting up SSL certificate and properties in pgadmin4 and
> java.
>
> Our requirement is :-
>  we should connect ssl-enabled port by configuring ssl-properties and
> providing certificates path in any client tool such as pgadmin4 or using
> java.
>
>
> Below are some questions that needs to clarified :-
>
> How to enable SSL in Postgres database?
>
> How to establish the SSL connection from the client (Eg. Java )? Do we
> need to add any certifications at client side for SSL authentication ?
>
> Do we have any documentation for SSL ?

https://www.postgresql.org/docs/current/ssl-tcp.html
>
>
> Thanks & Regards
> Sujay Kadam
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com