X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id CB25111F627C for ; Wed, 29 Mar 2006 17:57:07 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 41969-02 for ; Wed, 29 Mar 2006 17:57:06 -0400 (AST) X-Greylist: delayed 23:30:16.803908 by SQLgrey- Received: from hotmail.com (bay103-f5.bay103.hotmail.com [65.54.174.15]) by postgresql.org (Postfix) with ESMTP id F04C911F6249 for ; Wed, 29 Mar 2006 17:57:04 -0400 (AST) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Wed, 29 Mar 2006 13:57:03 -0800 Message-ID: Received: from 65.54.174.200 by by103fd.bay103.hotmail.msn.com with HTTP; Wed, 29 Mar 2006 21:56:59 GMT X-Originating-IP: [65.242.105.130] X-Originating-Email: [salemb4@hotmail.com] X-Sender: salemb4@hotmail.com In-Reply-To: From: "Salem Berhanu" To: mallah.rajesh@gmail.com Cc: pgsql-admin@postgresql.org Subject: Re: postgres and persistant connections (using Apache::DBI) Date: Wed, 29 Mar 2006 21:56:59 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 29 Mar 2006 21:57:03.0578 (UTC) FILETIME=[B69293A0:01C6537B] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.559 required=5 tests=[AWL=-0.360, DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44, MSGID_FROM_MTA_HEADER=0] X-Spam-Score: 1.559 X-Spam-Level: * X-Archive-Number: 200603/349 X-Sequence-Number: 21106 Rajesh, Thanks for the suggestion. I tried what you told me. In my startup script I did use Apache2::Status; use Apache::DBI; before any modules that use DB connect were loaded. I also included the handler for perl-status in the conf file as you mentioned. However as I access different pages the database connection doesn't persist. I check netstat on the db server and I see connections from the web server that appear and disappear. I checked http://my_mod_perl_server/perl-status and it has a link that says DBI connections but with no data in it. Also I wasn't clear on why you are not using connect_on_init. Thanks Salem >From: "Rajesh Kumar Mallah" >To: "Salem Berhanu" >CC: pgsql-admin@postgresql.org >Subject: Re: [ADMIN] postgres and persistant connections (using >Apache::DBI) >Date: Wed, 29 Mar 2006 21:32:47 +0530 > >On 3/29/06, Salem Berhanu wrote: > > I am trying to set up a persistent connection to a handful of postgres >dbs > > at startup using Apache::DBI (also using mod_perl) > > Here is what I am doing but I am not sure how to check if it's working > > right. > > > > in httpd.conf I have > > PerlRequire startup.pl > > > > in startup.pl I load all the necessary perl modules and also include the > > lines > > > > use Apache::DBI; > > Apache::DBI->connect_on_init( host, login, password); > > > > This doesn't seem to make any difference. I was expecting to see >database > > connections when I restarted apache and that all queries would get >handled > > by these connections. Is this a wrong assumption? What is the >expectation > > and what would be a good test when setting up persistent connections to >a > > postgres db? > >We use DBI connection pooling with postgres in mod_perl environment >and it works fine. We however do not use connect_on_init as Apache::DBI >docs say that all DBI->connect() anyway gets intercepted transparently. > >please take care that > >1. Make sure Apache::DBI is loaded before any module that issues a DB >connect. >you can even load Apache::DBI from httpd.conf by >PerlRequire Apache::DBI > >2. You can know if Apache::DBI is effective or not by installing >Apache::Status >,load Apache::Status before Apache::DBI in that case and add a Location >section in the httpd.conf like: > > >--------------- httpd.conf--------------------- >PerlModule Apache::Status >PerlModule Apache::DBI > > > SetHandler perl-script > PerlHandler Apache::Status > >------------------------------------------------------ >point your browser to http://your_mod_perl_server/perl-status >and check the section about database conenctions. > >i am not sure if this info answers your question but >i am describing something that works for me. > >regds >Rajesh Kumar Mallah. > > > > > > > > > > > > Thanks much > > Salem > > > > > > > > ---------------------------(end of broadcast)--------------------------- > > TIP 2: Don't 'kill -9' the postmaster > >