Assistance Needed: SSL Configuration in Postgres and Client Connection Setup

Hi Team.

I would like to inform you that I have successfully enabled SSL on a different port in Postgres using pgbouncer. Specifically, I have modified the default port to 6432 and configured it for SSL while setting up pgbouncer to listen to a non-SSL port at 5432.

However, I have noticed that some team members are connecting directly to the SSL-enabled port without uploading any certificates or configuring SSL properties in pgadmin4 or Java. Our requirement is to establish SSL connections by properly configuring SSL properties and providing certificate paths in client tools such as pgadmin4 or Java.

In light of this, I would like to clarify a few things:

How can we enable SSL in Postgres database?

What is the process for establishing an SSL connection from a client like Java? Do we need to add any certifications at the client-side for SSL authentication?

Do we have any documentation or resources available that can guide us in configuring SSL?


Thanks & Regards
Sujay Kadam