Skip site navigation (1) Skip section navigation (2)

Re: too many clients. Can they wait in line?

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>
Cc: "Peter Michaux" <petermichaux(at)gmail(dot)com>, <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: too many clients. Can they wait in line?
Date: 2008-03-09 12:38:26
Message-ID: 8B555CC1-F391-459C-9A72-B80F0071C5D4@fastcrypt.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc


In response to

Responses

pgsql-jdbc by date

Next:From: Peter MichauxDate: 2008-03-09 18:08:54
Subject: Re: too many clients. Can they wait in line?
Previous:From: Heikki LinnakangasDate: 2008-03-09 09:02:04
Subject: Re: too many clients. Can they wait in line?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group