From: Suprabhat <suprabhatm@gmail.com>
To: pgsql-bugs@postgresql.org
Subject: BUG #5995: connection pooling not working
Date: Wed, 27 Apr 2011 11:55:13 GMT
Message-ID: <201104271155.p3RBtDwu092291@wwwmaster.postgresql.org> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: suprabhatm@gmail.com, pgsql-bugs@postgresql.org
Subject: Re: BUG #5995: connection pooling not working
In-Reply-To: <201104271155.p3RBtDwu092291@wwwmaster.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox