[pgpool-general: 9118] Re: Problems with connection management

[Tatsuo Ishii]

> I am having a problem with the management of connections at the pgpool
> level, it is giving me the following error in the pgpool log.
> 
> [[No Connection]] LOG:  child exiting, 100 connections reached
[snip]

This is not an error. Just indicating child_max_connections parameter
works as expected.

> I attach the current configuration of the parameters corresponding to
> connection management.
> 
> process_management_mode = dynamic
> num_init_children = 900
> min_spare_children = 10
> max_spare_children = 20
> max_pool = 4
> #child_life_time = 3min
> child_max_connections = 100
> connection_life_time = 180
> client_idle_limit = 180
> 
> In postgres I have set max_connections = 1000.
> 
> I would appreciate any suggestions on a configuration improvement to avoid
> this connection refused error.
>  Also mention that currently there have not been more than 300 active
> connections.

You can disable the parameter (thus avoiding the messages) by
disabling it.

child_max_connections = 0

Best reagards,
--
Tatsuo Ishii
SRA OSS LLC
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp