Re: BUG #14994: Email alert

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: lovemewara1(at)gmail(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14994: Email alert
Date: 2017-12-30 08:02:19
Message-ID: 20171230080219.GA5799@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Sat, Dec 30, 2017 at 07:14:02AM +0000, PG Bug reporting form wrote:
> How to set auto Email alert after failure slave node in Streaming
> Replication please suggest me.

This is usually the kind of job where a monitoring process running
checks periodically is fit for. You should do things on both the
primary, by for example looking at pg_stat_replication, and the standby
by looking at its status and how its WAL receiver goes, which is where
the new system view pg_stat_wal_receiver becomes handy.
--
Michael

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2017-12-30 14:31:13 BUG #14995: repmgr_funcs lib is missing in rpm
Previous Message PG Bug reporting form 2017-12-30 07:14:02 BUG #14994: Email alert