Force SSL connection

Started by Rakesh Kumarover 8 years ago2 messagesgeneral
Jump to latest
#1Rakesh Kumar
rakeshkumar464@outlook.com

In PG 9.6 or PG 10, is there a way to force only SSL based connections coming
from pgadmin or dbeaver.

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Rakesh Kumar (#1)
Re: Force SSL connection

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