X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 53247D1D1A4 for ; Wed, 25 Feb 2004 01:30:19 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 68103-09 for ; Tue, 24 Feb 2004 21:30:19 -0400 (AST) Received: from trade-india.com (ns5.trade-india.com [66.234.10.13]) by svr1.postgresql.org (Postfix) with SMTP id EE25DD1BA9F for ; Tue, 24 Feb 2004 21:30:14 -0400 (AST) Received: (qmail 24514 invoked from network); 25 Feb 2004 01:33:38 -0000 Received: from unknown (HELO trade-india.com) (203.145.130.142) by ns5.trade-india.com with SMTP; 25 Feb 2004 01:33:38 -0000 Message-ID: <403BFAA6.8090906@trade-india.com> Date: Wed, 25 Feb 2004 07:00:14 +0530 From: Rajesh Kumar Mallah User-Agent: Mozilla Thunderbird 0.5 (X11/20040208) X-Accept-Language: en-us, en MIME-Version: 1.0 To: James Taylor Cc: "'pgsql-admin@postgresql.org'" Subject: Re: Idle processes won't die References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/348 X-Sequence-Number: 12522 Dear James, We have been using mod_perl with PostgreSQL in web environment without any problems. I hope you are already using Apache::DBI for connection pooling. Regds Mallah James Taylor wrote: > Hi everyone, using mod_perl with Postgres, postgres is on the same > server as the webserver. Perl is opening connections, and then > closing them at the end of every script, however Pg > is refusing to close the connection, and I have tons and tons of Idle > processes sitting around, which causes the web site to crash because > the maximum number of pgsql processes gets reached after the site is > accessed 32 times. From everything I know about Perl, even if I > didn't implicitly close the database handles, the perl garbage handler > would close them for me. Is there some sort of configuration for > postgres to disallow all these idle processes from sticking around, so > they maybe... close themselves after 5 seconds or something similar? > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org >