Skip site navigation (1) Skip section navigation (2)

Re: Cacti + PostgreSQL Graphing

From: "Marc G(dot) Fournier" <scrappy(at)hub(dot)org>
To: Greg Smith <greg(at)2ndquadrant(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Cacti + PostgreSQL Graphing
Date: 2010-03-03 21:43:41
Message-ID: alpine.BSF.2.00.1003031739311.5800@hub.org (view raw or flat)
Thread:
Lists: pgsql-general
Greg (or anyone out there) ... have you had any experience with using 
check_postgres.pl --action=dbstats with Cacti?  I'm getting, in my 
cacti.log, a result of:

SPINE: Poller[0] Host[124] DS[2619] SCRIPT: 
/usr/local/bin/check_postgres.pl --action=dbstats --host=192.0.2.23 
--dbuser=monitor --dbpass=monitor --dbname=test, output: U

The specific problem bing the 'output: U', which should look something 
like:

output: backends:1 commits:97645 rollbacks:5 read:177034 hit:6872718 
idxscan:0 idxtupread:0 idxtupfetch:0 idxblksread:2199 idxblkshit:3 
seqscan:3 seqtupread:1000110 ret:24845129 fetch:2956289 ins:2201738 
upd:3999 del:312 dbname:test

Google seems to have a bunch of stuff talking about 'output: U', but 
dating back to '06 and older ... the command runs fine (and fast) from the 
command line, so not a timeout ...

So, anyone using dbstats with the newest version of Cacti, and have it 
working?

On Mon, 1 Mar 2010, Marc G. Fournier wrote:

>
> Greg, before I start hacking away at it, do you have any examples of using 
> check_postgres_dbstats with cacti?  rather not recreate teh wheel is someone 
> has already done it ...
>
> thx ...
>
> On Sat, 27 Feb 2010, Greg Smith wrote:
>
>> Marc G. Fournier wrote:
>>> We are mainly a nagios / cacti environment, and I came across...
>> 
>> Why start with Cacti then?  There's way more Nagios integration available; 
>> the little check_pgsql that comes with it (I think it's still there), and 
>> the whole list at 
>> http://exchange.nagios.org/directory/Plugins/Databases/PostgresQL
>> 
>> I'd think that starting with http://bucardo.org/wiki/Check_postgres for 
>> example would put you way ahead of anything that's available for Cacti.
>> 
>> -- 
>> Greg Smith  2ndQuadrant US  Baltimore, MD
>> PostgreSQL Training, Services and Support
>> greg(at)2ndQuadrant(dot)com   www.2ndQuadrant.us
>> 
>> 
>
> ----
> Marc G. Fournier                        Hub.Org Hosting Solutions S.A.
> scrappy(at)hub(dot)org                                     http://www.hub.org
>
> Yahoo:yscrappy    Skype: hub.org    ICQ:7615664    MSN:scrappy(at)hub(dot)org
>

----
Marc G. Fournier                        Hub.Org Hosting Solutions S.A.
scrappy(at)hub(dot)org                                     http://www.hub.org

Yahoo:yscrappy    Skype: hub.org    ICQ:7615664    MSN:scrappy(at)hub(dot)org

In response to

Responses

pgsql-general by date

Next:From: Michael GouldDate: 2010-03-03 21:52:18
Subject: Re: Scratching my head why results are different between machines.
Previous:From: Igor NeymanDate: 2010-03-03 21:31:45
Subject: Re: Auto VACUUM

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group