[pgpool-general: 6404] Re: How to measure or detect run out of connection from pgpool perspective ?
ishii at sraoss.co.jp
Sun Feb 3 08:11:52 JST 2019
> I have setup a two server cluster replicate using streaming replication and
> watchdog is handling vip. Here are the general connections settings:
> num_init_children = 128
> max_pool = 4
> listen_backlog_multiplier = 2
> max_connections = 512
> superuser_reserved_connections = 3
> How to measure or detect run out of connection from pgpool perspective ?
Currently there's no way to measure run out of connection to frontend.
> is it help counting last column pool_connected equal 1 of command
Yes. Count number of lines emitted by pcp_proc_info (without -a). Let
the number be n. If (n / (number of live backend)) =
num_init_children, Pgpool-II runs out connection.
> -a ? if pgpool run out of connection will give any hint or log message on
> pgpool's log ?
BTW, upcoming Pgpool-II 4.1 will have a capability if connection is
run out, no additional connection is accepted (similar behavior to
See "reserved_connections" parameter described in:
SRA OSS, Inc. Japan
More information about the pgpool-general