Re: PostgreSQL monitoring

From: Rodrigo Hjort <rodrigo(dot)hjort(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: Jaume Sabater <jsabater(at)gmail(dot)com>, Vladimir Rusinov <vladimir(at)greenmice(dot)info>, Marcelo Martins <pglists(at)zeroaccess(dot)org>
Subject: Re: PostgreSQL monitoring
Date: 2009-12-08 13:35:58
Message-ID: 731083980912080535p5f608101odb06e76b17debbe6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)greenmice(dot)info>

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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Bradley Kieser 2009-12-09 11:14:25 Cannot increase connection limit?
Previous Message Scott Marlowe 2009-12-08 04:12:29 Re: pg DATA folder restoration