Share via

Failure in connecting to postgre azure database

Hassan 45 Reputation points
2023-10-07T06:50:39.3633333+00:00

hi I am trying to connect to my Azure Postgre database in the data factory, but I am encountering an error everytime, also I have updated my firewall settings to allow access from all IP addresses, but the issue is still there
the error is : 28000: no pg_hba.conf entry for host "20.42.2.58" (screenshot attached)
can somebody please provide a solution? i am stuck in this from hours

Screenshot (296).png

Azure Database for PostgreSQL
0 comments
Accepted answer
  1. Vinodh247 34,746 Reputation points MVP Volunteer Moderator
    2023-10-07T14:04:37.94+00:00

    Hi Hassan:

    Thanks for reaching out to Microsoft Q&A.

    Please perform the following steps sequentially to see if it works for you

    1. Check if the ssl connection under server parameters has been set to non mandatory for postgres services in azure
    2. Restart the server
    3. In azure portal set the require_secure_transport from server parameters to OFF
    4. Add firewall rule 0.0.0.0 - 255.255.255.255 --(Obviously not the best solution but you can take this into consideration only if nothing worked and you want to get through this anyhow)

    Please 'Upvote'(Thumbs-up) and 'Accept' as answer if the reply was helpful. This will be benefitting other community members who face the same issue.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.