Kirk Bowe wrote: > Unfortunately after a couple of hours of moderate use Postgres reaches its > max_clients level (which is set below max httpds in httpd.conf)
This is usually caused by mistakes in your connection calls where they have slightly different connect info resulting in multiple connections. > At this point there's no > work being done, so presumably the handles aren't being freed. Database handles are not supposed to be freed. That's the point of Apache::DBI. However, you should only have one per httpd process. > Does anyone have any tips on how to, at this point, go about detecting > where the handle leak might be (which I'm presuming is the problem)? http://perl.apache.org/docs/1.0/guide/databases.html#Debugging_Apache__DBI > should Template::Toolkit be avoided altogether when using mod_perl and > database connectivity? TT is not related to this. It works great with mod_perl. - Perrin
