Hola a tod@s,

Estoy presentando un problema con el manejo de conexiones a nivel de
pgpool, me está arrojando el siguiente error en el log de pgpool.

[[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

Adjunto configuración actual de los parámetros correspondientes al manejo
de conexiones.

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

En postgres tengo configurado el max_connections = 1000.

Agradecería alguna sugerencia acerca de una mejora en la configuración para
evitar este error de conexiones rechazadas.
 Mencionar además, que actualmente no se han superado las 300 conexiones
activas.

Saludos.

Reply via email to