Thread: [GENERAL] Force SSL connection

[GENERAL] Force SSL connection

From
rakeshkumar464
Date:
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

Re: [GENERAL] Force SSL connection

From
Tom Lane
Date:
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