Thread: Cannot connect to Postgres without allowing non-SSL connections in pg_hba.conf
Cannot connect to Postgres without allowing non-SSL connections in pg_hba.conf
From
Daniel Buus
Date:
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