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

From: sujay kadam <sujaykadam02(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Cc: pratap(dot)some(at)bristlecone(dot)com
Subject: SSL Enablement in Postgres via Client App like PG-ADMIN-4, Java.
Date: 2023-05-05 13:49:55
Message-ID: CAAUgb-t9MNmGxe_FbNY10WJZzgQSo6KCyN7UwJYOUfkPLQ90xw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 ?

Thanks & Regards
Sujay Kadam

Responses

Browse pgsql-general by date

  From Date Subject
Next Message sujay kadam 2023-05-05 13:54:30 Assistance Needed: SSL Configuration in Postgres and Client Connection Setup
Previous Message jian he 2023-05-05 11:03:24 customized function to Reconstructs the creating command for a role.