I am currently building an intranet site which uses a Postgresql database 
backend. Unfortunately the database server is opening more files for every 
SQL request from the web site. This quickly leads to a crash after the 
kernels file table has filled up.

As of today I have no idea about the cause of the problem. Initially I 
blamed Apache::DBI and therefore I disabled it, adding $dbh-> disconnect 
statements to my code. However this has not solved the problem.

My server runs the following software:

FreeBSD 4.0 or FreeBSD 4.2 stable
Apache 1.3
ModPerl
Apache::DBI (disabling this doesn't change anything)
HTML::Mason

Any ideas on the cause of the problems. Any similar experiences?

Thanks in advance for your reply.


Frank Sonnemans