Re: pgpool Connections Distributions Among Nodes

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: "Kumar, Virendra" <Virendra(dot)Kumar(at)guycarp(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pgpool Connections Distributions Among Nodes
Date: 2018-01-29 16:52:07
Message-ID: 74bdc07c-05ca-1a6a-3c3c-d6a8d3df0c9d@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 01/29/2018 08:19 AM, Kumar, Virendra wrote:
> Hi Gurus,
>
> We have 4-node cluster (1 master and 3 hot standby).  We are using
> pgpool as load balancer. We have an observation where if application
> requests for 3 connections, pgpool connects to all 4 servers and I see 3
> connections on each of them. I was expecting it have a total of 3
> connections from either of 4 servers but I can easily see 12 connections
> in all.
>
> Can somebody shed some light on it.
>
> Please let me know if you need more information.

I would say the contents of your config file at the least.

>
> Regards,
>
> Virendra
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Glauco Torres 2018-01-29 16:52:33 Re: pgpool Connections Distributions Among Nodes
Previous Message Rakesh Kumar 2018-01-29 16:50:46 Re: PG Sharding