Re: too many clients

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   |
+------------------------------+---------------------------------------------+