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