X-Original-To: pgsql-interfaces-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B8C6FDA02E for ; Tue, 4 Oct 2005 10:41:14 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 24114-09 for ; Tue, 4 Oct 2005 13:41:02 +0000 (GMT) Received: from web53512.mail.yahoo.com (web53512.mail.yahoo.com [206.190.39.66]) by svr1.postgresql.org (Postfix) with SMTP id 423E5DA122 for ; Tue, 4 Oct 2005 10:11:16 -0300 (ADT) Received: (qmail 95233 invoked by uid 60001); 4 Oct 2005 13:11:10 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=bruAvqLWhWCRUbNBB0wZd+rB5Y4WZrZm99UX70itXW86CTiZlVavI684WswIRqpdqqbq+/jvPwa3BdGGXDuTaELvLYZ/BtdFOeFNtZG62M0bNHg8veyjdijsM/RpxY6pvaSF5BghK6pw2I27ez/DWqGx3IRAMd3W6O4pcxB255E= ; Message-ID: <20051004131110.95231.qmail@web53512.mail.yahoo.com> Received: from [209.87.238.132] by web53512.mail.yahoo.com via HTTP; Tue, 04 Oct 2005 06:11:10 PDT Date: Tue, 4 Oct 2005 06:11:10 -0700 (PDT) From: jing han Subject: how to monitor connections to postgres database To: postgres interface MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.115 required=5 tests=[AWL=-0.136, DNS_FROM_RFC_ABUSE=0.374, FROM_ENDS_IN_NUMS=0.516, FROM_HAS_ULINE_NUMS=0.361] X-Spam-Level: * X-Archive-Number: 200510/2 X-Sequence-Number: 5764 Hello, I met a problem that the max_connections configured in postgresql.conf are exceeded when my program runs for 6 days. I set max_connections = 30. I use watch -d "ps ax |grep postgres" to monitor how many connections to database, I found my program have at most 6 connections to database. I couldn't figure out how the max_connections are exceeded. Is this the only way to monitor how many connections to database? Are there other ways to monitor how many connections to database? Any help will be highly appreciated. jing __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com