Azure Database for PostgreSQL
An Azure managed PostgreSQL database service for app development and deployment.
662 questions
no pg_hba.conf entry error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 60%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EEC%3C/text%3E%3C/svg%3E)
Evan Corkrean
25
Reputation points
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
{count} votes
-
Evan Corkrean 25 Reputation points
2023-09-01T00:07:36.3466667+00:00 Update: I got the same error with psql 15.4
-
ShaktiSingh-MSFT 9,566 Reputation points Microsoft Employee2023-09-01T03:45:44.0033333+00:00 Hi
Evan Corkrean •,Welcome to Microsoft Q&A forum and thanks for using Azure Services.
As I understand, you are getting error: "no pg_hba.conf entry error" in Azure Database for PostgreSQL Flexible Server.
Could you please refer to the solutions provided in this Stackoverflow thread and see if this helps in your case:
https://stackoverflow.com/questions/1406025/no-pg-hba-conf-entry-for-host
Let us know if it does not help and share configuration details of your server.
Thanks
-
Evan Corkrean 25 Reputation points
2023-09-01T18:29:30.7433333+00:00 That's not possible because I can't access the database.
I also tested from a Linux VM and got the same result.
Interestingly, it worked when I tested with DBeaver from my mac, though the psql client still doesn't work.
-
ShaktiSingh-MSFT 9,566 Reputation points Microsoft Employee
2023-09-04T06:15:22.9333333+00:00 Hi
Evan Corkrean •,I would recommend you to please file a support ticket for deeper investigation and in case if you don't have a support plan, do let us know here so that we can check on other options to unblock you.
Thanks
-
Evan Corkrean 25 Reputation points
2023-09-05T16:43:21.65+00:00 Hi Shakti, I'm able to connect with the UI console and that's fine for my use case.
-
ShaktiSingh-MSFT 9,566 Reputation points Microsoft Employee
2023-09-06T04:16:28.4666667+00:00 Hi
Evan Corkrean •,Great to hear that you could make it through.
Could you please share the solution here on Q&A with the Community so that people facing similar issues could be benefitted.
Thanks
Sign in to comment