no pg_hba.conf entry error

Evan Corkrean 25 Reputation points
2023-08-31T23:58:54.5+00:00

Hello,

I receive the following error when trying to connect to an Azure Database for PostgreSQL flexible server.

psql: error: connection to server at "example.postgres.database.azure.com" (20.39.50.159), port 5432 failed: SSL error: certificate verify failed

connection to server at "postgrestestcorkrean.postgres.database.azure.com" (20.39.50.159), port 5432 failed: FATAL: no pg_hba.conf entry for host "redacted_ip", user "evan", database "postgres", no encryption

I spun this DB up about 30 min ago. I've confirmed that my IP is allowed in the firewall and public access is enabled.

psql client version = 14.9

PostgreSQL version = 15.3

Azure Database for PostgreSQL
{count} votes