[PGPOOL-II] Problemas con manejo de conexiones

From: Francisco Peña <franciscopenar1988(at)gmail(dot)com>
To: pgsql-es-ayuda(at)postgresql(dot)org
Subject: [PGPOOL-II] Problemas con manejo de conexiones
Date: 2024-06-06 18:08:35
Message-ID: CAOa=9_P0n2ADKCZ6mQYKdbNVfOpqv98B_eJa4F4UiTYfYCkASg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Hola a tod(at)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.

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Henry Interiano 2024-06-08 05:21:55 Descargar RPM de Postgresql 11
Previous Message Alvaro Herrera 2024-06-06 17:33:16 Re: Archivado particularmente voluminoso.