Re: too many clients

From: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>
To: "pgsql-jdbc (at) postgresql (dot) org" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Re: too many clients
Date: 2003-11-04 14:19:50
Message-ID: 20031104141950.A25432@bacon
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc


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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Nick Fankhauser 2003-11-04 14:22:25 Re: too many clients
Previous Message Glenn Holmer 2003-11-04 13:34:35 too many clients