Thread: BUG #14994: Email alert

BUG #14994: Email alert

From
PG Bug reporting form
Date:
The following bug has been logged on the website:

Bug reference:      14994
Logged by:          ram mewra
Email address:      lovemewara1@gmail.com
PostgreSQL version: 9.6.0
Operating system:   centos 6
Description:

How to set auto Email alert after failure slave node in Streaming
Replication  please suggest me.


Re: BUG #14994: Email alert

From
Michael Paquier
Date:
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

Attachment