Cannot connect to Postgres without allowing non-SSL connections in pg_hba.conf

Поиск
Список
Период
Сортировка
От Daniel Buus
Тема Cannot connect to Postgres without allowing non-SSL connections in pg_hba.conf
Дата
Msg-id CABt26P+xoZjUhvMzYjH60mK4Zr4X8pOW9QOfV4QANq-XR0jzVQ@mail.gmail.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: Marcus Crowley
Дата:
Сообщение: White text on white background in Edit Data JSONB column
Следующее
От: Dave Page
Дата:
Сообщение: pgAdmin 4 v1.0-beta3 released