From Bugzilla Helper: User-Agent: Mozilla/5.0 (X11; U; Linux i686; ja-JP; rv:1.4.1) Gecko/20031030 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 mod_auth_pgsql. 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): mod_auth_pgsql-2.0.1-3 How reproducible: Always 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 authentification. 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. Additional info:
mod_auth_pgsql version 2.0.2b1, this problem may fixed . Changelog: >> 2.0.2b1 2003-10-06 (Giuseppe Tanzilli <info>) >> - connection reuse logic is now optional and default is off >> - connection reuse will open one connection per child (was one per dir config)
This was fixed in FC3 and later, thanks for the report.