Обсуждение: too many clients. Can they wait in line?

I'm using postgresql-8.2-506.jdbc3.jar with PostgreSQL 8.2.4 and I am
seeing "FATAL: sorry, too many clients already". Can I somehow have
these threads wait in line until a connection is available? Perhaps
with some sort of timeout of 30 seconds?

Thanks,
Peter

Peter Michaux wrote:
> I'm using postgresql-8.2-506.jdbc3.jar with PostgreSQL 8.2.4 and I am
> seeing "FATAL: sorry, too many clients already". Can I somehow have
> these threads wait in line until a connection is available? Perhaps
> with some sort of timeout of 30 seconds?

Try pgpool.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com

On 9-Mar-08, at 5:02 AM, Heikki Linnakangas wrote:

> Peter Michaux wrote:
>> I'm using postgresql-8.2-506.jdbc3.jar with PostgreSQL 8.2.4 and I am
>> seeing "FATAL: sorry, too many clients already". Can I somehow have
>> these threads wait in line until a connection is available? Perhaps
>> with some sort of timeout of 30 seconds?
>
> Try pgpool.

Since this is a java application I'd suggest you use a java pool
apache's dbcp

Dave
>
>
> --
>  Heikki Linnakangas
>  EnterpriseDB   http://www.enterprisedb.com
>
> --
> Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc

On Sun, Mar 9, 2008 at 4:38 AM, Dave Cramer <pg@fastcrypt.com> wrote:
>
>  On 9-Mar-08, at 5:02 AM, Heikki Linnakangas wrote:
>
>  > Peter Michaux wrote:
>  >> I'm using postgresql-8.2-506.jdbc3.jar with PostgreSQL 8.2.4 and I am
>  >> seeing "FATAL: sorry, too many clients already". Can I somehow have
>  >> these threads wait in line until a connection is available? Perhaps
>  >> with some sort of timeout of 30 seconds?
>  >
>  > Try pgpool.
>
>  Since this is a java application I'd suggest you use a java pool
>  apache's dbcp

I tried dbcp and it seems to do the trick nicely.

Thanks,
Peter