Re: PGBouncer - Load balancing options

Hello,

> On Oct 10, 2024, at 03:02, Ravi Varma Addala <advarma@microsoft.com> wrote:
>
> Hello Team,I wanted to reach out to provide some insight into a request from my customer regarding their multiple
PostgreSQLFlex instances with PGbouncer. Currently, they are utilizing an Azure Load Balancer which distributes
connectionsusing the Round-robin mechanism. However, they are now seeking a solution that allows for load balancing
basedon the number of connections, meaning the Load Balancer should route requests to the instance with the least
numberof connections.Unfortunately, Azure Standard Load Balancer does not support this capability. However, Application
Gatewaydoes offer this functionality - Microsoft.Network/applicationGateways - Bicep, ARM template & Terraform AzAPI
reference| Microsoft Learn 
>  ASK:
>
>     • Has anyone implemented this kind of approach and is it possible?
>     • Can we do health probe with PostgreSQL to get no of connections metric?

Even though you mention pgbouncer in the subject:, your questions tare about proprietary products that your employer
providesand supports.  It's probably best to ask internally about their functionality; the community almost certainly
doesnot have any better insight into them.