Postgres Pro
Downloads
Home   >   mailing lists

Re: too many clients. Can they wait in line? - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: too many clients. Can they wait in line?
Date
Msg-id 8B555CC1-F391-459C-9A72-B80F0071C5D4@fastcrypt.com
Whole thread Raw
In response to Re: too many clients. Can they wait in line?  ("Heikki Linnakangas" <heikki@enterprisedb.com>)
Responses Re: too many clients. Can they wait in line?  ("Peter Michaux" <petermichaux@gmail.com>)
List pgsql-jdbc
Tree view 
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

pgsql-jdbc by date:

Previous
From: "Heikki Linnakangas"
Date:
Subject: Re: too many clients. Can they wait in line?
Next
From: "Peter Michaux"
Date:
Subject: Re: too many clients. Can they wait in line?