Re: BUG #4637: FATAL: sorry, too many clients already - Mailing list pgsql-bugs

chetan wrote:
> The following bug has been logged online:
>
> Bug reference:      4637
> Logged by:          chetan
> Email address:      chethanp@inat.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