Pgbounce issue with Azure Postgres Flexible server

Alberto Salazar 1

Hi, I'm having issues using pgbouce with an Azure Postgres Flexible Server. When I configure and try to connect my app throught pgbounce I always get "no pg_hba.conf entry for host "xxx.xxx.xxx.xxx", user "xxxxxxxxx", database "xxxxx", SSL off

I did the same test with a Single server version and It worked perfect.

I re-check that the Ip address where added into the firewall rules dashboard into Postgres Flexible Server

Thanks for your support

Anurag Sharma 17,586 Reputation points

2021-01-25T08:58:55.597+00:00

Hi @Alberto Salazar , welcome to Microsoft Q&A forum. Apologies for the trouble you are facing.

I have reached out internally to product group on the same issue and will update the thread at the earliest when receive a response.
Navtej Singh Saini 4,221 Reputation points Microsoft Employee

2021-02-04T17:20:54.363+00:00

@Alberto Salazar

Hopefully you were able to raise the issue with support and please share the ticket number. Please do let us know the issue is resolved or we can traction for you if the issue is still open.

Regards
Navtej S

1 answer

Anurag Sharma 17,586 Reputation points

2021-01-28T11:31:39.4+00:00

Hi @Alberto Salazar , apologies for the delayed response and thanks for your patience.

I received the response back from PG and this looks difficult to troubleshoot remotely from our end.

It would be really helpful if you can raise a support ticket and then a Microsoft Engineer would be able to do a walkthrough with you about the issue and get it resolved.

Please let us know if you face any issue here or have any query on the same.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment