Re: PostgreSQL monitoring - Mailing list pgsql-admin

From Rodrigo Hjort
Subject Re: PostgreSQL monitoring
Date
Msg-id 731083980912080535p5f608101odb06e76b17debbe6@mail.gmail.com
Whole thread Raw
In response to Re: PostgreSQL monitoring  (Vladimir Rusinov <vladimir@greenmice.info>)
List pgsql-admin
Hello admins,

Based on these monitoring needs, I've posted an article called "PostgreSQL monitoring on ZABBIX" where I set up some parameters such as database size, cache hit ratio and success rate:

http://agajorte.blogspot.com/2009/12/postgresql-monitoring-on-zabbix.html

I also found out Vladimir's Zabbix Templates Collection, where several DBMS items are considered:

http://greenmice.info/en/node/136

For those interested in the subject: do you think there is any other valuable PostgreSQL-specific item to be monitored?

--
Best regards,

Rodrigo Hjort
SERPRO/CETEC/Curitiba
www.serpro.gov.br


2009/1/22 Vladimir Rusinov <vladimir@greenmice.info>

On Wed, Jan 21, 2009 at 8:30 PM, Jaume Sabater <jsabater@gmail.com> wrote:
On Wed, Jan 21, 2009 at 5:51 PM, Vladimir Rusinov
<vladimir@greenmice.info> 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)?

Of course you would but, honestly, it is not on top of my TODO list. I
will have to do them, eventually, but I don't see it happening in the
next 4 weeks. Feel free to get started with something and I'll
contribute with what I have as soon as I can (quite busy at work at
the moment, sorry). :)

Don't worry, I understand you. I'm just asking where I could find if your tools are completed and compare it to mine. Are you going to post link to this list?
It's also not on top of my TODO list, and I also think it should not be ready earlier then in 2-3 weeks. I'll post my templates and scripts to http://greenmice.info/ It's mostly on russian, but I'm translating most interesting posts to english, but it could take one more week. :( And I can also post link to this list if anyone interesed.

--
Vladimir Rusinov
http://greenmice.info/

pgsql-admin by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: pg DATA folder restoration
Next
From: Bradley Kieser
Date:
Subject: Cannot increase connection limit?