Re: Desperately need a magical PG monitoring tool

On 26/03/12 19:58, Andreas wrote:
> Hi,
>
> is there a tool for monitoring PG servers?

> How do you watch that all runs well ?

There are a number of tools. You might want to google around:
- nagios
- monit
- munin
There are plenty of others

Nagios is aimed at multi-server service monitoring (and alerting). So
you can keep track of 20 websites on 5 different servers etc.

Monit is more focused on monitoring/alerting/restarting on a single server.

Munin is about performance tracking and graphing. You can set it up to
alert if parameters get outside a set range.

For your scenario, I'd consider restoring the backup to another database
(on another server perhaps) and checking some suitable value (e.g. a max
timestamp in a frequently updated table). You could do all this from a
simple cron-job + perl script but you might want to consider one of the
tools mentioned above.

--
Richard Huxton
Archonet Ltd