Azure App Service can't connect to PostgreSQL Flexible server

Ben Luts 0

The firewall rules for Azure PostgreSQL Flexible server are not being applied. We are constantly getting 28000: pg_hba.conf rejects connection for host "xx.xx.xx.xx". Although for testing purposes we have allowed any IP-Address. It is still generating this error. We really need assistance with this.

Sai Raghunadh M 2,795 Reputation points Microsoft External Staff

2025-03-04T10:32:41.8466667+00:00

Hi @Ben Luts

Thanks for the Question and using Microsoft Q&ACould you please provide the connection string of the server? Are you using Microsoft entra Authentication?
Ben Luts 0 Reputation points

2025-03-04T10:52:39.78+00:00

Hi Sai,
That would be
Server=scheduler-dbs.postgres.database.azure.com;Database=<database>;Port=5432;User Id=<MS Entra >;Password=<Ms Entra Token>;Ssl Mode=Require;
Sai Raghunadh M 2,795 Reputation points Microsoft External Staff

2025-03-05T17:05:46.4533333+00:00

Hi @ Ben Luts

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution. please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Ben Luts 0 Reputation points

2025-03-06T06:39:39.7+00:00

Hi, I haven't had the chance to check to proposed resolution yet, will make time today & keep it updated here.
Sai Raghunadh M 2,795 Reputation points Microsoft External Staff

2025-03-07T07:24:40.4733333+00:00

Hi @ Ben Luts,

Did you get a chance to review my answer? Let me know if you found a resolution. If not, we will assist you further.

1 answer

Sai Raghunadh M 2,795 Reputation points Microsoft External Staff

2025-03-04T16:18:12.2166667+00:00

Hi @ Ben Luts

Could you disable the SSL mode and try again, please?

Here is the documentation on how to disable SSL:

https://learn.microsoft.com/en-us/previous-versions/azure/postgresql/single-server/concepts-ssl-connection-security#using-the-azure-portal

Please refer to these threads that might help you: https://stackoverflow.com/questions/44031721/why-does-connection-to-my-postgres-server-in-azure-fail-if-my-app-does-not-have

https://stackoverflow.com/questions/62301317/azure-database-for-postgresql-server-no-pg-hba-conf-entry-for-host

please try postgreSQL and Microsoft Entra authentication.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure App Service can't connect to PostgreSQL Flexible server

1 answer

Your answer