Re: Async replication: how to get an alert on failure

From: pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Async replication: how to get an alert on failure
Date: 2018-09-06 06:17:49
Message-ID: 1536214669218-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Karl,

Hope my mail finds you in good time.

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

Did you configure ssh ??

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

Could you please share your views on how to achieve it? Thanks in Advance.

Regards,
Pavan

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-general-f1843780.html

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thiemo Kellner 2018-09-06 06:28:37 Re: PostgreSQL intenal scheduler?
Previous Message jimmy 2018-09-06 05:23:21 How to install pgAgent on windows for postresql-bigsql-10.5