Assistance Needed: SSL Configuration in Postgres and Client Connection Setup

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, muhammad(dot)shaiek(at)bristlecone(dot)com
Subject: Assistance Needed: SSL Configuration in Postgres and Client Connection Setup
Date: 2023-05-05 13:54:30
Message-ID: CAAUgb-u=_c6ZCaoUTTN7hHXubs3bcu3pu7aBzSjU8EbGEASzEQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Sky Lendar 2023-05-05 13:55:21 sorting problem with distinct on()
Previous Message sujay kadam 2023-05-05 13:49:55 SSL Enablement in Postgres via Client App like PG-ADMIN-4, Java.