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

On Thu, Jul 13, 2017 at 10:38 AM, Michael Paquier <michael(dot)paquier(at)gmail(dot)com
> wrote:

> On Thu, Jul 13, 2017 at 7:23 PM, Jeff Janes <jeff(dot)janes(at)gmail(dot)com> 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