Re: BUG #4637: FATAL: sorry, too many clients already

From: Stefan Kaltenbrunner <stefan(at)kaltenbrunner(dot)cc>
To: chetan <chethanp(at)inat(dot)in>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4637: FATAL: sorry, too many clients already
Date: 2009-02-03 09:59:22
Message-ID: 4988157A.3050409@kaltenbrunner.cc
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

chetan wrote:
> The following bug has been logged online:
>
> Bug reference: 4637
> Logged by: chetan
> Email address: chethanp(at)inat(dot)in
> PostgreSQL version: plus 8.3
> Operating system: windows xp
> Description: FATAL: sorry, too many clients already
> Details:
>
> 2009-02-03 12:41:58,109 INFO [STDOUT] 12:41:58,109 WARN
> [JDBCExceptionReporter] SQL Error: 0, SQLState: 53300
> 2009-02-03 12:41:58,109 INFO [STDOUT] 12:41:58,109 ERROR
> [JDBCExceptionReporter] FATAL: sorry, too many clients already
> 2009-02-03 12:41:58,109 ERROR [STDERR]
[...]

This is not a bug - you simple hit the maximum limit of allowed clients
set in postgresql.conf.
If you want to create more connections increase the max_connections
variable or look into connection pooling.

Stefan

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bjoern Weitzig 2009-02-03 12:49:22 BUG #4638: Bug with Geometry in Array
Previous Message chetan 2009-02-03 09:24:32 BUG #4637: FATAL: sorry, too many clients already