Cannot connect to Postgres without allowing non-SSL connections in pg_hba.conf - Mailing list pgadmin-support

From Daniel Buus
Subject Cannot connect to Postgres without allowing non-SSL connections in pg_hba.conf
Date
Msg-id CABt26P+xoZjUhvMzYjH60mK4Zr4X8pOW9QOfV4QANq-XR0jzVQ@mail.gmail.com
Whole thread Raw
List pgadmin-support
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



pgadmin-support by date:

Previous
From: Marcus Crowley
Date:
Subject: White text on white background in Edit Data JSONB column
Next
From: Dave Page
Date:
Subject: pgAdmin 4 v1.0-beta3 released