Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Monitoring of a hot standby with a largely idle master - Mailing list pgsql-general

From Jeff Janes
Subject Re: [GENERAL] Monitoring of a hot standby with a largely idle master
Date
Msg-id CAMkU=1zqXGpOTTH1HRVisZebQuJdGmvG6Ei2nxpFb_D25pH-TQ@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Monitoring of a hot standby with a largely idle master  (Michael Paquier <michael.paquier@gmail.com>)
Responses Re: [GENERAL] Monitoring of a hot standby with a largely idle master
List pgsql-general
Tree view
On Thu, Jul 13, 2017 at 10:38 AM, Michael Paquier <michael.paquier@gmail.com> wrote:
On Thu, Jul 13, 2017 at 7:23 PM, Jeff Janes <jeff.janes@gmail.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

pgsql-general by date:

Previous
From: marcelo
Date:
Subject: Re: [GENERAL] What is exactly a schema?
Next
From: "Zhu, Joshua"
Date:
Subject: [GENERAL] puzzled by deletion performance