Postgres Pro
Downloads
Home   >   mailing lists

Re: too many clients - Mailing list pgsql-jdbc

From Paul Thomas
Subject Re: too many clients
Date
Msg-id 20031104141950.A25432@bacon
Whole thread Raw
In response to too many clients  (Glenn Holmer <gholmer@weycogroup.com>)
Responses Re: too many clients  (Glenn Holmer <gholmer@weycogroup.com>)
List pgsql-jdbc
Tree view 
On 04/11/2003 13:34 Glenn Holmer wrote:
> What does this mean and how do I diagnose it?
>
> java.sql.SQLException: FATAL:  Sorry, too many clients already
>
> Not all the Postgres databases on this machine are experiencing this.
> One of them is using pooling with Tomcat and the JNDI interface.
>

You've probably reached max_connections. Try upping the value in your
postgresql.conf. You'll need to restart the back-end for it to take effect.

--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for the Smaller
Business |
| Computer Consultants         |
http://www.thomas-micro-systems-ltd.co.uk   |
+------------------------------+---------------------------------------------+

pgsql-jdbc by date:

Previous
From: Glenn Holmer
Date:
Subject: too many clients
Next
From: "Nick Fankhauser"
Date:
Subject: Re: too many clients