Hi there :)
I'm trying to connect to a Postgresql server (running in a Docker
container) from pgAdmin (most recent 3 stable as well as most recent 4
beta).
Connecting to the server works fine with Postico. With pgAdmin,
however, I get the error, "SSL error: sslv3 alert handshake failure
FATAL: no pg_hba.conf entry for host "172.17.0.1", user "postgres",
database "nosco", SSL off" as long as my pg_hba.conf looks like this:
local all all trust
host all,replication replication samehost md5
hostssl all,replication replication samehost md5
hostssl all all samenet md5
hostssl nosco all .nos.co md5
The error message mentions "SSL off," so I tried adding "host all all
samenet md5" to pg_hba.conf, and this allows pgAdmin 4 to connect with
SSL still required in its connection settings. pgAdmin 3, however,
will still fail to connect with SSL required, but with the
non-SSL-allowing rule in pg_hba.conf it will now successfully connect
if I explicitly disable SSL in the connection settings.
Any idea why this is?
Thanks in advance,
Daniel