[pgpool-general: 9117] Problems with connection management

[Francisco Peña]

Hello,

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
[[No Connection]] LOG:  child exiting, 100 connections reached
[[No Connection]] LOG:  child exiting, 100 connections reached
[[No Connection]] LOG:  child exiting, 100 connections reached
[[No Connection]] LOG:  child exiting, 100 connections reached
[[No Connection]] LOG:  child exiting, 100 connections reached
[[No Connection]] LOG:  child exiting, 100 connections reached
[[No Connection]] LOG:  child exiting, 100 connections reached
[[No Connection]] LOG:  child exiting, 100 connections reached
[[No Connection]] LOG:  child exiting, 100 connections reached
[[No Connection]] LOG:  child exiting, 100 connections reached
[[No Connection]] LOG:  child exiting, 100 connections reached
[[No Connection]] LOG:  child exiting, 100 connections reached
[[No Connection]] LOG:  child exiting, 100 connections reached
[[No Connection]] LOG:  child exiting, 100 connections reached
[[No Connection]] LOG:  child exiting, 100 connections reached
[[No Connection]] LOG:  child exiting, 100 connections reached
[[No Connection]] LOG:  child exiting, 100 connections reached
[[No Connection]] LOG:  child exiting, 100 connections reached
[[No Connection]] LOG:  child exiting, 100 connections reached
[[No Connection]] LOG:  child exiting, 100 connections reached
[[No Connection]] LOG:  child exiting, 100 connections reached
[[No Connection]] LOG:  child exiting, 100 connections reached

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.

Greetings.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20240606/1ec18225/attachment.htm>