Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id 9B0AB1337B4E
	for <pgsql-bugs-postgresql.org@mail.postgresql.org>;
	Wed, 27 Apr 2011 08:55:14 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 54814-03 for
	<pgsql-bugs-postgresql.org@mail.postgresql.org>;
	Wed, 27 Apr 2011 11:55:14 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from wwwmaster.postgresql.org (wwwmaster.postgresql.org
	[217.196.146.204])
	by mail.postgresql.org (Postfix) with ESMTP id EB4FE1337B49
	for <pgsql-bugs@postgresql.org>; Wed, 27 Apr 2011 08:55:13 -0300 (ADT)
Received: from wwwmaster.postgresql.org (wwwmaster.postgresql.org
	[217.196.146.204])
	by wwwmaster.postgresql.org (8.14.3/8.14.3) with ESMTP id
	p3RBtDRt092292
	for <pgsql-bugs@postgresql.org>; Wed, 27 Apr 2011 11:55:13 GMT
	(envelope-from www@wwwmaster.postgresql.org)
Received: (from www@localhost)
	by wwwmaster.postgresql.org (8.14.3/8.14.3/Submit) id p3RBtDwu092291;
	Wed, 27 Apr 2011 11:55:13 GMT (envelope-from www)
Date: Wed, 27 Apr 2011 11:55:13 GMT
Message-Id: <201104271155.p3RBtDwu092291@wwwmaster.postgresql.org>
To: pgsql-bugs@postgresql.org
Subject: BUG #5995: connection pooling not working
From: "Suprabhat" <suprabhatm@gmail.com>
Content-Type: text/plain; charset=utf-8
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 201104/204
X-Sequence-Number: 30123


The following bug has been logged online:

Bug reference:      5995
Logged by:          Suprabhat
Email address:      suprabhatm@gmail.com
PostgreSQL version: 8.4
Operating system:   ubuntu
Description:        connection pooling not working
Details: 

Hi, we are using java jsp front end to develop a web based application which
runs fine using odbc:jdbc link for mssql. The moment we switched over to
using postgresql, it kept on telling FATAL: too many connections already and
there are too many postgres processes on the server. We have used connection
pooling methods after unsuccessfully using pgpool2. I am really wondering
how the big companies are using this database without any issues. Probably
we are doing some basics wrong. 

Total number of connections we are trying to make is something around 300
concurrently. 

Please suggest what should be do. This is very very urgent. 

Regards,

Suprabhat