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 6B693DA0B2 for ; Tue, 4 Oct 2005 10:41:46 -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 25637-10 for ; Tue, 4 Oct 2005 13:41:36 +0000 (GMT) Received: from web53513.mail.yahoo.com (web53513.mail.yahoo.com [206.190.39.67]) by svr1.postgresql.org (Postfix) with SMTP id 41A6FDA063 for ; Tue, 4 Oct 2005 10:21:56 -0300 (ADT) Received: (qmail 11146 invoked by uid 60001); 4 Oct 2005 13:21:51 -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=4OTomgRxEzH1sMvmQmoD+iJUaiQnqtb8pl4GpOnY0FB1tS8YybGlVFt9ixa/p0mKe2vKdVrMc+WmYjyXNvH0NyVk/V+2RKfEdOd+qB5Ta3zcl9RtLCAJlqmjmAubmRScTSQTwGjeu/UBTTr+Ut6b+NdkcjraKOPFx7/PUwFSRtI= ; Message-ID: <20051004132151.11144.qmail@web53513.mail.yahoo.com> Received: from [209.87.238.132] by web53513.mail.yahoo.com via HTTP; Tue, 04 Oct 2005 06:21:51 PDT Date: Tue, 4 Oct 2005 06:21:51 -0700 (PDT) From: jing han Subject: how to monitor dead connections to postgresql 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.125 required=5 tests=[AWL=-0.126, 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/3 X-Sequence-Number: 5765 Hello, After 6 days busy running, one of my process dead of cannot connect to database, and the log message shows that exceeding max_connections. The max_connections = 30. By running watch -d "ps ax |grep postgres" I only find 6 connections to database, there must be dead connections laying around and I cannot see them. Can you tell me how to monitor dead connections to postgres database? Thank you! jing __________________________________ Yahoo! Mail - PC Magazine Editors' Choice 2005 http://mail.yahoo.com