[pgpool-general: 5292] Re: Connections to backends

Tatsuo Ishii ishii at sraoss.co.jp
Fri Feb 3 23:38:34 JST 2017

> Hello.
> I have a following configuration:
> 3 backends with replication in master-slave mode.
> 2 pgpools with delegate_IP and watchdog, with weights of backends as
> following:
> master = 1
> both slaves = 0
> My understanding is that pgpool shouldnt make requests to backend nodes with weight of 0.
> The question is why does pgpool establishes a connections to those nodes?

Ideally in your case Pgpool-II only needs to connect to the master
only. It's already on our TODO list.

> Second question, something i couldn't understand from reading a documentation: why does number of connections to backends is much more than number of connections to frontend?


Best regards,
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php

More information about the pgpool-general mailing list