Re: Ayuda con pgpool

From: Miguel Angel Hernandez Moreno <miguel(dot)hdz(dot)mrn(at)gmail(dot)com>
To: Matias Israel Malpica Escobar <Matias(dot)Malpica(at)thyssenkrupp(dot)com>
Cc: "pgsql-es-ayuda(at)postgresql(dot)org" <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Re: Ayuda con pgpool
Date: 2011-10-20 23:32:15
Message-ID: CAGYOd3rM_S8mX73ujPaAxgxX+=xkuw9gwaXbWNnw21qD3xKCCg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

checa tu max_conection de postgres por ue probablemente sea eso

El 20 de octubre de 2011 17:20, Matias Israel Malpica Escobar <
Matias(dot)Malpica(at)thyssenkrupp(dot)com> escribió:

> Hey una pregunta, quise hacer una prueba a mi pgpool le puse un maximo de
> conexiones a postgresql de 2, y luego utilice pgbench para mandar 10
> conexiones a pgpool, y termina en error! No se supone que deberia poner las
> conexiones en cola????? Alguien sabe por que? Este es el error:
>
> Connection to database "test" failed:
> FATAL: sorry, too many clients already
> Client 1 aborted in establishing connection.
> Connection to database "test" failed:
> FATAL: sorry, too many clients already
> Client 2 aborted in establishing connection.
> Connection to database "test" failed:
> FATAL: sorry, too many clients already
> Client 3 aborted in establishing connection.
> Connection to database "test" failed:
> FATAL: sorry, too many clients already
> Client 4 aborted in establishing connection.
> Connection to database "test" failed:
> FATAL: sorry, too many clients already
> Client 5 aborted in establishing connection.
> Connection to database "test" failed:
> FATAL: sorry, too many clients already
> Client 6 aborted in establishing connection.
> Connection to database "test" failed:
> FATAL: sorry, too many clients already
> Client 7 aborted in establishing connection.
> Connection to database "test" failed:
> FATAL: sorry, too many clients already
> Client 8 aborted in establishing connection.
> Connection to database "test" failed:
>

--
ISC Miguel Angel Hernandez Moreno

In response to

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message Alvaro Herrera 2011-10-21 00:19:03 Re: Ayuda con pgpool
Previous Message CarloS Sing Ramos 2011-10-20 23:27:13 Re: [pgsql-es-ayuda] Re: [pgsql-es-ayuda] Re: [pgsql-es-ayuda] ¿Cual es el numero de palabras en la documentacion oficial?