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 A1A2711F65DA for ; Tue, 28 Mar 2006 18:26:52 -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 29177-08 for ; Tue, 28 Mar 2006 18:26:51 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id E037311F65D3 for ; Tue, 28 Mar 2006 18:26:49 -0400 (AST) Received: from hotmail.com (bay103-f37.bay103.hotmail.com [65.54.174.47]) by svr4.postgresql.org (Postfix) with ESMTP id 550625AF024 for ; Tue, 28 Mar 2006 22:26:50 +0000 (GMT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Tue, 28 Mar 2006 14:26:47 -0800 Message-ID: Received: from 65.54.174.200 by by103fd.bay103.hotmail.msn.com with HTTP; Tue, 28 Mar 2006 22:26:45 GMT X-Originating-IP: [65.242.105.130] X-Originating-Email: [salemb4@hotmail.com] X-Sender: salemb4@hotmail.com From: "Salem Berhanu" To: pgsql-admin@postgresql.org Subject: postgres and persistant connections (using Apache::DBI) Date: Tue, 28 Mar 2006 22:26:45 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-OriginalArrivalTime: 28 Mar 2006 22:26:47.0868 (UTC) FILETIME=[B3ADDFC0:01C652B6] X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=1.919 required=5 tests=[DNS_FROM_RFC_ABUSE=0.479, DNS_FROM_RFC_POST=1.44, MSGID_FROM_MTA_HEADER=0] X-Spam-Score: 1.919 X-Spam-Level: * X-Archive-Number: 200603/323 X-Sequence-Number: 21080 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? Thanks much Salem