Re: Monitoring of a hot standby with a largely idle master

[Jeff Janes <jeff.janes@xxxxxxxxx>]

On Thu, Jul 13, 2017 at 10:38 AM, Michael Paquier <michael.paquier@xxxxxxxxx> wrote:

On Thu, Jul 13, 2017 at 7:23 PM, Jeff Janes <jeff.janes@xxxxxxxxx> wrote:
>
> I think that pg_stat_wal_receiver should be crossreferenced in
> https://www.postgresql.org/docs/9.6/static/hot-standby.html, near the same
> place which it crossreferences table 9-79.  That would make it more
> discoverable.

Hm. Hot standby may not involve streaming replication. What about a
paragraph here instead?
https://www.postgresql.org/docs/devel/static/warm-standby.html#streaming-replication

In the monitoring subsection, we could tell that on a standby the WAL
receiver status can be retrieved from this view when changes are
streamed. What do you think?

That works for me.

Cheers,

Jeff