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 5275B9FB260 for ; Mon, 10 Jul 2006 04:54:32 -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 37693-08 for ; Mon, 10 Jul 2006 04:54:22 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nf-out-0910.google.com (nf-out-0910.google.com [64.233.182.184]) by postgresql.org (Postfix) with ESMTP id 8B7369FB256 for ; Mon, 10 Jul 2006 04:54:22 -0300 (ADT) Received: by nf-out-0910.google.com with SMTP id x30so343094nfb for ; Mon, 10 Jul 2006 00:54:21 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=pWB3dSVzReb4ezROxP2USKkNzVGAtpNrn2+EKehQknrz0xAmMD+gX5brOIXXBDojRLt3c/j2Y2n/+SqpQ4dkmqk7UvkBUfjCZaBlmcPR95jkduCGzQVhVI9mMUClrw2Tkl48CrNQmbZ4Eyn93h5n9QD6sVBv09kzuHJV+6jvIPA= Received: by 10.49.65.14 with SMTP id s14mr3424202nfk; Mon, 10 Jul 2006 00:54:20 -0700 (PDT) Received: by 10.48.230.20 with HTTP; Mon, 10 Jul 2006 00:54:20 -0700 (PDT) Message-ID: <9e4684ce0607100054q6e149fddk80bb9a8827e2cf5@mail.gmail.com> Date: Mon, 10 Jul 2006 09:54:20 +0200 From: "hubert depesz lubaczewski" To: "Jeff Frost" Subject: Re: How are ppl monitoring PostgreSQL ... ? What is being monitored ... ? Cc: "ogjunk-pgjedan@yahoo.com" , pgsql-admin@postgresql.org In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_59495_7010974.1152518060709" References: <9e4684ce0606110810n50f8c44cjf02a273a65aac0c2@mail.gmail.com> <20060707043738.62724.qmail@web50312.mail.yahoo.com> <9e4684ce0607070037g2a66d830sabc77aa2d3116229@mail.gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/50 X-Sequence-Number: 22296 ------=_Part_59495_7010974.1152518060709 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline On 7/9/06, Jeff Frost wrote: > > Do you already have a MRTG plugin for postgres that you've written and if > so, > care to share it with the rest of us? Or better yet, share it with the > mrtg.org folks? I was thinking of writing one, but if you have one > already, I > hate to reinvent the wheel. > this is not mrtg plugin. i use snmpd (net-snmpd to be exact), and connect custom scripts to it using "exec" directive in config. so basically i have series of scripts which all look more or less like this: #!/bin/bash psql -U pgdba -d some_database -qAt 'select .....'; and a series of: Exec some-name /etc/snmpd/addons/somescript.sh that's all. depesz -- http://www.depesz.com/ - nowy, lepszy depesz ------=_Part_59495_7010974.1152518060709 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On 7/9/06, Jeff Frost <jeff@frostconsultingllc.com> wrote:
Do you already have a MRTG plugin for postgres that you've written and if so,
care to share it with the rest of us?  Or better yet, share it with the
mrtg.org folks?  I was thinking of writing one, but if you have one already, I
hate to reinvent the wheel.

this is not mrtg plugin. i use snmpd (net-snmpd to be exact), and connect custom scripts to it using "exec" directive in config.
so basically i have series of scripts which all look more or less like this:
#!/bin/bash
psql -U pgdba -d some_database -qAt 'select .....';

and a series of:
Exec some-name /etc/snmpd/addons/somescript.sh

that's all.

depesz

--
http://www.depesz.com/ - nowy, lepszy depesz ------=_Part_59495_7010974.1152518060709--