Обсуждение: 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
. 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?
Engelmann
__________________________________________________
Faça ligações para outros computadores com o novo Yahoo! Messenger
http://br.beta.messenger.yahoo.com/
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 monitoringHi,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 missingThe 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: > 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? > > Engelmann > __________________________________________________ > Faça ligações para outros computadores com o novo Yahoo! Messenger > http://br.beta.messenger.yahoo.com/