Azure Database for PostgreSQL error: FATAL: password authentication failed for user

0x3N3JVhPUV 0 Reputation points
2024-08-31T21:23:50.7066667+00:00

Hello,

For some reason, I cannot access my PostgreSQL Database. I'm using a Managed Identity (MI).
I already red the following article and it doesn'y apply to my situation: https://video2.skills-academy.com/en-us/azure/postgresql/flexible-server/troubleshoot-password-authentication-failed-for-user

Error:
`2024-08-31 20:40:51.175 GMT [213] FATAL: password authentication failed for user "postgres"

`2024-08-31 20:40:51.175 GMT [213] DETAIL: Connection matched file "/opt/bitnami/postgresql/conf/pg_hba.conf" line 1: "host all all 0.0.0.0/0 md5"``

Azure Database for PostgreSQL

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. ShaktiSingh-MSFT 15,056 Reputation points
    2024-09-03T04:41:17.1733333+00:00

    Hi @0x3N3JVhPUV ,

    Welcome to Microsoft Q&A forum.

    As I understand, you are getting error: FATAL: password authentication failed for user in Azure Database for PostgreSQL.

    As mentioned by you, document https://video2.skills-academy.com/en-us/azure/postgresql/flexible-server/troubleshoot-password-authentication-failed-for-user has been referred and did not help in your case.

    If you're still facing issues after following the guidance provided, please don't hesitate to file a support ticket.

    Thanks

    0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.