| From: | Karl Denninger <karl(at)denninger(dot)net> |
|---|---|
| To: | richter(at)simkorp(dot)com(dot)br |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Async replication: how to get an alert on failure |
| Date: | 2012-08-02 03:22:41 |
| Message-ID: | 5019F281.8070109@denninger.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 8/1/2012 5:29 PM, Edson Richter wrote:
> I have few PostgreSQL servers established with replication.
> Now, is there any way to receive an e-mail in case of error during
> synchronization?
> I mean, is there an script I can run (maybe every 5 minutes) that will
> check if replication is stolen, and send an e-mail in case of failure?
>
> Thanks,
> --
I wrote a small program that goes to each of the servers in the
replication group and checks its status on the log, computes the
difference, and if off by more than "X" bytes prints a notification.
If this is run from the cron it will remain silent unless the offset is
breached at which point it will emit an email to the submitting owner of
the job.
--
-- Karl Denninger
/The Market Ticker ®/ <http://market-ticker.org>
Cuda Systems LLC
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John R Pierce | 2012-08-02 03:44:04 | Re: How to get results with zero count from this query? |
| Previous Message | dud | 2012-08-02 03:14:23 | How to get results with zero count from this query? |