From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Andreas <maps(dot)on(at)gmx(dot)net> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Desperately need a magical PG monitoring tool |
Date: | 2012-03-26 20:52:18 |
Message-ID: | 4F70D702.9090005@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Tim Uckun | 2012-03-26 23:05:00 | Backing up through a database connection (not pg_dump) |
Previous Message | Yangyang | 2012-03-26 20:32:16 | DBT-3 workload running error: tmp_query.sql is missing |