Re: [GENERAL] Async replication: how to get an alert on failure

[Edson Richter]

Em 02/08/2012 00:22, Karl Denninger escreveu:

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 ®/ 
Cuda Systems LLC


Can you please share the query are you using so I can have a start point?

Thanks,

Edson

Re: [GENERAL] Async replication: how to get an alert on failure

[Karl Denninger]

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 ®/ 
Cuda Systems LLC

Re: [GENERAL] Async replication: how to get an alert on failure

[Toby Corkindale]

On 02/08/12 10:04, 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 (cron?) I can run (maybe every 5 minutes)
that will check if replication is stolen, and send an e-mail in case of
failure?


I created a little Perl script that just connects to the master and 
queries the pg_stat_replication statistics.


It notes if (a) the client has disconnected entirely, or (b) if the 
client's replay position has still not reached the position that the 
master was in last time we checked. (So if you run the check every five 
minutes, you'll get a warning if the client is more than five minutes 
lagged behind the master)


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general