X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 17D709FA2A0; Sat, 10 Jun 2006 21:24:28 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 30562-10; Sat, 10 Jun 2006 21:24:26 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- X-Greylist: domain auto-whitelisted by SQLgrey- Received: from hub.org (hub.org [200.46.204.220]) by postgresql.org (Postfix) with ESMTP id 9B0069F9AD3; Sat, 10 Jun 2006 21:24:27 -0300 (ADT) Received: from localhost (mx1.hub.org [200.46.208.251]) by hub.org (Postfix) with ESMTP id 4CD0F290C29; Sat, 10 Jun 2006 21:24:21 -0300 (ADT) Received: from hub.org ([200.46.204.220]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 40186-05; Sat, 10 Jun 2006 21:24:23 -0300 (ADT) Received: from ganymede.hub.org (blk-7-151-244.eastlink.ca [71.7.151.244]) by hub.org (Postfix) with ESMTP id E1DE3290C1E; Sat, 10 Jun 2006 21:24:17 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1000) id D851F3B5C7; Sat, 10 Jun 2006 21:24:26 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id D425A376E2; Sat, 10 Jun 2006 21:24:26 -0300 (ADT) Date: Sat, 10 Jun 2006 21:24:26 -0300 (ADT) From: "Marc G. Fournier" X-X-Sender: scrappy@ganymede.hub.org To: "Joshua D. Drake" cc: "Marc G. Fournier" , pgsql-admin@postgresql.org Subject: Re: How are ppl monitoring PostgreSQL ... ? What is being In-Reply-To: <448B41E9.8030609@commandprompt.com> Message-ID: <20060610211619.K1114@ganymede.hub.org> References: <20060610152251.M1114@ganymede.hub.org> <448B41E9.8030609@commandprompt.com> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/101 X-Sequence-Number: 22063 On Sat, 10 Jun 2006, Joshua D. Drake wrote: > Marc G. Fournier wrote: >> >> The subject kinda says it all ... I know there are SNMP patches available >> out there now, but without those ... ? > > We use Nagios to call shell scripts that perform specific requests to a > PostgreSQL server. Usually over SSH via psql, but you could use anything. 'k, so what are you testing for? Just that a query runs? time it takes to run? specific results? SELECT count(1) FROM pg_connections; would be a good one to graph ... ---- Marc G. Fournier Hub.Org Networking Services (http://www.hub.org) Email . scrappy@hub.org MSN . scrappy@hub.org Yahoo . yscrappy Skype: hub.org ICQ . 7615664