On Mon, 21 Nov 2005, Manideep Kalisetty wrote:
Bug reference: 2060
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.2.2
Description: Issue with Data base connection
Details:
I am using postgresql-8.1dev-402.jdbc3.jar JDBC driver and websphere
application server. Even though I am successfully closing connections, the
error message I am receivng is "Backend start-up failed: FATAL 1: Sorry,
too many clients already". Please refer to the Exception report below:
Well, something is leaving connections open. Checking the results of
SELECT * FROM pg_stat_activity; will tell you what database and username
they are connected to which may help. While this code doesn't appear to
be using a connection pool, perhaps you have another application that is
using a pool that is configured to open too many connections? Still, the
most likely cause is a coding error failing to close connections.
Kris Jurka
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
