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:
Regards, Dave.