no pg_hba.conf entry error

Question

no pg_hba.conf entry error

Evan Corkrean 35

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

Evan Corkrean 35 Reputation points

2023-09-01T00:07:36.3466667+00:00

Update: I got the same error with psql 15.4
Evan Corkrean 35 Reputation points

2023-09-01T18:29:30.7433333+00:00

Hi @SSingh-MSFT

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.
SSingh-MSFT 16,371 Reputation points Moderator

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 35 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.
SSingh-MSFT 16,371 Reputation points Moderator

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
Jacek Tomaszewski 5 Reputation points

2024-10-14T15:26:35.6733333+00:00

To me the problem was that I was trying to connect to the Postgres using non-SSL (from a node.js application). After adding a ssl: true to connection config in my app, it was okay.

1 answer

Your answer

Evan Corkrean 35 Reputation points

2023-09-01T00:07:36.3466667+00:00

Update: I got the same error with psql 15.4
Evan Corkrean 35 Reputation points

2023-09-01T18:29:30.7433333+00:00

Hi @SSingh-MSFT

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.
SSingh-MSFT 16,371 Reputation points Moderator

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 35 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.
SSingh-MSFT 16,371 Reputation points Moderator

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
Jacek Tomaszewski 5 Reputation points

2024-10-14T15:26:35.6733333+00:00

To me the problem was that I was trying to connect to the Postgres using non-SSL (from a node.js application). After adding a ssl: true to connection config in my app, it was okay.

Answer 1

SSingh-MSFT 16,371 Moderator

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

Share via

no pg_hba.conf entry error

1 answer

Your answer