Red Hat Bugzilla – Bug 111385
Overuse connections to a PostgreSQL server
Last modified: 2007-11-30 17:10:34 EST
From Bugzilla Helper:
User-Agent: Mozilla/5.0 (X11; U; Linux i686; ja-JP; rv:1.4.1)
Description of problem:
I use mod_auth_pgsql which connect to other PostgreSQL Server.
When after authentification is used, connections to PostgreSQL is keep
alive (IDLE) for long time. Then number of connedtion reach max number
32, and I couldn't use the DB Server for other aims. 29/32 is used by
DB Server PostgreSQL 7.3.3 (compile myself)
It is in a other server on the same network.
Web Server httpd-2.0.47-10 (FC1)
Version-Release number of selected component (if applicable):
Steps to Reproduce:
1. Edit /etc/httpd/conf.d/auth_pgsql enable authentification to root
of the web server.
2. Access to any contents on the server by a brouser with
3. Finish brouser which saw the web server.
3. Check process on DB Server by ps alx. You can see process from Web
server for long time.
mod_auth_pgsql version 2.0.2b1, this problem may fixed .
>> 2.0.2b1 2003-10-06 (Giuseppe Tanzilli <email@example.com>)
>> - connection reuse logic is now optional and default is off
>> - connection reuse will open one connection per child (was one per
This was fixed in FC3 and later, thanks for the report.