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.klaver@xxxxxxxxxxx
