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
