Re: [GENERAL] Force SSL connection - Mailing list pgsql-general

From Tom Lane
Subject Re: [GENERAL] Force SSL connection
Date
Msg-id 32048.1508163544@sss.pgh.pa.us
Whole thread Raw
In response to [GENERAL] Force SSL connection  (rakeshkumar464 <rakeshkumar464@outlook.com>)
List pgsql-general
rakeshkumar464 <rakeshkumar464@outlook.com> writes:
> In PG 9.6 or PG 10, is there a way to force only SSL based connections coming
> from pgadmin or dbeaver.

I think you could set that up with a custom pg_hba.conf entry or two.
Something like

hostnossl ... pgadmin ... reject

before the line that would normally accept the connection.
        regards, tom lane


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

pgsql-general by date:

Previous
From: Osahon Oduware
Date:
Subject: [GENERAL] Using Substitution Variables In PostgreSQL
Next
From: Achilleas Mantzios
Date:
Subject: Re: [GENERAL] Using Substitution Variables In PostgreSQL