Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 493FA632417 for ; Wed, 21 Jan 2009 13:33:12 -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 54289-04 for ; Wed, 21 Jan 2009 13:33:09 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from pyrrha.dalibo.net (pyrrha.dalibo.net [212.85.154.72]) by mail.postgresql.org (Postfix) with ESMTP id D03286323F1 for ; Wed, 21 Jan 2009 13:33:08 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by pyrrha.dalibo.net (Postfix) with ESMTP id D61D2578070; Wed, 21 Jan 2009 18:33:06 +0100 (CET) Received: from pyrrha.dalibo.net ([127.0.0.1]) by localhost (pyrrha.dalibo.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 1m06RIyPVm5M; Wed, 21 Jan 2009 18:33:06 +0100 (CET) Received: by pyrrha.dalibo.net (Postfix, from userid 1011) id B7F03578074; Wed, 21 Jan 2009 18:33:06 +0100 (CET) Received: from [192.168.0.12] (lan31-6-82-238-146-117.fbx.proxad.net [82.238.146.117]) by pyrrha.dalibo.net (Postfix) with ESMTP id 499D6578070; Wed, 21 Jan 2009 18:33:02 +0100 (CET) Message-ID: <49775C4B.6000402@dalibo.com> Date: Wed, 21 Jan 2009 18:32:59 +0100 From: =?UTF-8?B?Q8OpZHJpYyBWaWxsZW1haW4=?= Organization: Dalibo User-Agent: Mozilla-Thunderbird 2.0.0.17 (X11/20081018) MIME-Version: 1.0 To: Vladimir Rusinov CC: Jaume Sabater , Marcelo Martins , pgsql-admin@postgresql.org Subject: Re: PostgreSQL monitoring References: <14369888-7712-48EC-966C-7A0878360C22@zeroaccess.org> <3786f7bb0901190756h5079eb3ap12bcedbe4ff2053@mail.gmail.com> In-Reply-To: X-Enigmail-Version: 0.95.7 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit 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/101 X-Sequence-Number: 31148 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Vladimir Rusinov a écrit : > On Mon, Jan 19, 2009 at 6:56 PM, Jaume Sabater wrote: > >> 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. > > > Oh, I have exactly the same in my plans. Where it would possible to download > them (if would)? > I did something in that way, check_postgres.pl is a good script to start from (add a zabbix output perhaps). I stop working on that because zabbix is too painfull to use (*for me*). Here some draft note about zabbix+check_postgres...Hope it can help. Agent side: zabbix_agentd.conf : UserParameter=pgs[*],sudo -u postgres /usr/local/share/zabbix/check_postgres.pl --output=simple --db=$2 --action=$1 $3 | head -n 1 UserParameter=pgm[*],sudo -u postgres /usr/local/share/zabbix/check_postgres.pl - --output=mrtg --db=$2 --action=$1 $3 | head -n 1 sudoers : Runas_Alias DB = postgres User_Alias SUPERVISOR = zabbix Cmnd_Alias CHECK_PG = /usr/local/share/zabbix/check_postgres.pl SUPERVISOR ALL=(DB) NOPASSWD: CHECK_PG init checksum : sudo su -s /bin/bash - zabbix sudo -u postgres /usr/local/share/zabbix/check_postgres.pl --db=DBNAME - --action=settings_checksum --critical=0 Server side: pgs : check_postgres.pl output simple pgs[ACTION,DBNAME] pgm : check_postgres.pl output mrtg pgs[ACTION,DBNAME,EXTRA] - -- Cédric Villemain Administrateur de Base de Données Cel: +33 (0)6 74 15 56 53 http://dalibo.com - http://dalibo.org -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkl3XDgACgkQo/dppWjpEvz1LQCcDpd88zLVFSiFpqmA6Fr6y7rF LqMAn2z2SdI4BoceJf9elq72c1OytiHE =J5LP -----END PGP SIGNATURE-----