Async replication: how to get an alert on failure

From: Edson Richter <richter(at)simkorp(dot)com(dot)br>
To: pgsql-general(at)postgresql(dot)org
Subject: Async replication: how to get an alert on failure
Date: 2012-08-01 22:29:57
Message-ID: 5019ADE5.4050800@simkorp.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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,
--

*Edson Carlos Ericksson Richter*
/SimKorp Informática Ltda/
Fone: (51) 3366-7964
Celular: (51)9318-9766/(51) 8585-0796
Embedded Image

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Edson Richter 2012-08-02 00:04:01 Async replication: how to get an alert on failure
Previous Message Michael Nolan 2012-08-01 20:59:53 Re: Streaming replication and high query cancellation values