Automatic monitoring

________________________________

From: pgsql-general-owner@postgresql.org [mailto:pgsql-general-owner@postgresql.org] On Behalf Of Henrique Engelmann
Sent: 31 January 2006 16:06
To: pgsql-general@postgresql.org
Subject: [GENERAL] Automatic monitoring

Hi,

We´ve many postgresql servers running in linux Redhat/Fedora boxes in our enterprise and we´re looking for some tool to help us to administer and monitor those systems. This tool should monitor some basic linux and postgresql parameters like:

. memory usage
. swapping
. disk i/o queue
. cpu queue
. buffer cache effectiveness
. backup script erros
. table indexes missing

The ideia is to let an agent monitor the systems and if some threshold is reached an email will be send to our system.

Does anybody know some monitoring software that can do something similar?

Or have a suggestion of how I could develop some kind of software?

Nagios would probably work well, with some custom plugins in the language of your choice:

http://www.nagios.org

Regards, Dave.

Nagios and snmp

http://www.nagios.org/

On Jan 31, 2006, at 9:06 AM, Henrique Engelmann wrote: