Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 4C14E6324F6 for ; Tue, 20 Jan 2009 14:34:16 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 43764-10 for ; Tue, 20 Jan 2009 14:34:05 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from app1.ihackr.net (app1.ihackr.net [209.61.157.9]) by mail.postgresql.org (Postfix) with ESMTP id E96FA6324F1 for ; Tue, 20 Jan 2009 14:34:05 -0400 (AST) Received: by app1.ihackr.net (Postfix, from userid 502) id BACFD5902E3; Tue, 20 Jan 2009 12:34:03 -0600 (CST) Received: from office100-240.sat.rackspace.com (nat-vlan200.sat.rackspace.com [64.39.1.10]) by app1.ihackr.net (Postfix) with ESMTP id 62B405902BE; Tue, 20 Jan 2009 12:34:03 -0600 (CST) Cc: pgsql-admin@postgresql.org Message-Id: From: Marcelo Martins To: Jaume Sabater In-Reply-To: <3786f7bb0901190756h5079eb3ap12bcedbe4ff2053@mail.gmail.com> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v930.3) Subject: Re: PostgreSQL monitoring Date: Tue, 20 Jan 2009 12:34:03 -0600 References: <14369888-7712-48EC-966C-7A0878360C22@zeroaccess.org> <3786f7bb0901190756h5079eb3ap12bcedbe4ff2053@mail.gmail.com> X-Mailer: Apple Mail (2.930.3) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200901/71 X-Sequence-Number: 31118 Cool, I have actually been trying out Zabbiz 1.6.x now since I like it better than munin. Thanks, Marcelo PostgreSQL DBA Linux/Solaris System Administrator On Jan 19, 2009, at 9:56 AM, Jaume Sabater wrote: > On Mon, Jan 19, 2009 at 4:38 PM, Marcelo Martins > wrote: > >> Do you guys have any suggestions on monitoring tools for postgresql >> that >> would provide graphing of data & alerts ? >> I have looked and tried out hyperic, munin, Nimbus but was hoping to >> something better. > > To monitor I use the following: > > - pg_osmem: http://www.kennygorman.com/wordpress/?p=250 > - pg_buffercache (contrib package in Debian) > - pg_top: http://ptop.projects.postgresql.org/ > - ps > - pgd: http://www.kennygorman.com/wordpress/?p=260 > - iotop: http://guichaz.free.fr/iotop/ > > And I am in the process of writing a bunch of scripts that the Zabbix > agent will execute to feed the server with information, so that alerts > and graphs can be produced. > > -- > Jaume Sabater > http://linuxsilo.net/ > > "Ubi sapientas ibi libertas"