Re: [GENERAL] Monitoring of a hot standby with a largely idle master

2017-11-01 Thread Peter Eisentraut
On 7/27/17 16:14, Jeff Janes wrote: > On Wed, Jul 26, 2017 at 1:44 AM, Michael Paquier > mailto:michael.paqu...@gmail.com>> wrote: > > On Mon, Jul 24, 2017 at 9:08 PM, Jeff Janes > wrote: > > On Sun, Jul 16, 2017 at 8:47 AM, Michael Paquier > mailto:micha

Re: [GENERAL] Monitoring of a hot standby with a largely idle master

2017-07-27 Thread Jeff Janes
On Wed, Jul 26, 2017 at 1:44 AM, Michael Paquier wrote: > On Mon, Jul 24, 2017 at 9:08 PM, Jeff Janes wrote: > > On Sun, Jul 16, 2017 at 8:47 AM, Michael Paquier < > michael.paqu...@gmail.com> > > wrote: > >> What do you think about the patch attached? > > > > Looks OK. Should it mention specif

Re: [GENERAL] Monitoring of a hot standby with a largely idle master

2017-07-26 Thread Michael Paquier
On Mon, Jul 24, 2017 at 9:08 PM, Jeff Janes wrote: > On Sun, Jul 16, 2017 at 8:47 AM, Michael Paquier > wrote: >> What do you think about the patch attached? > > Looks OK. Should it mention specifically "On a hot standby" rather than "On > a standby"? Otherwise people might be left confused on

Re: [GENERAL] Monitoring of a hot standby with a largely idle master

2017-07-24 Thread Jeff Janes
On Sun, Jul 16, 2017 at 8:47 AM, Michael Paquier wrote: > On Fri, Jul 14, 2017 at 9:11 PM, Jeff Janes wrote: > > On Thu, Jul 13, 2017 at 10:38 AM, Michael Paquier > > wrote: > >> > >> On Thu, Jul 13, 2017 at 7:23 PM, Jeff Janes > wrote: > >> > > >> > I think that pg_stat_wal_receiver should be

Re: [GENERAL] Monitoring of a hot standby with a largely idle master

2017-07-16 Thread Michael Paquier
On Fri, Jul 14, 2017 at 9:11 PM, Jeff Janes wrote: > On Thu, Jul 13, 2017 at 10:38 AM, Michael Paquier > wrote: >> >> On Thu, Jul 13, 2017 at 7:23 PM, Jeff Janes wrote: >> > >> > I think that pg_stat_wal_receiver should be crossreferenced in >> > https://www.postgresql.org/docs/9.6/static/hot-st

Re: [GENERAL] Monitoring of a hot standby with a largely idle master

2017-07-15 Thread Lucas Possamai
2017-07-13 20:15 GMT+12:00 Michael Paquier : > On Thu, Jul 13, 2017 at 5:26 AM, Jeff Janes wrote: > > > > I think that none of the recovery information functions > > (https://www.postgresql.org/docs/9.6/static/functions- > admin.html#FUNCTIONS-RECOVERY-INFO-TABLE) > > can distinguish a hot standb

Re: [GENERAL] Monitoring of a hot standby with a largely idle master

2017-07-14 Thread Jeff Janes
On Thu, Jul 13, 2017 at 10:38 AM, Michael Paquier wrote: > On Thu, Jul 13, 2017 at 7:23 PM, Jeff Janes 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

Re: [GENERAL] Monitoring of a hot standby with a largely idle master

2017-07-13 Thread Michael Paquier
On Thu, Jul 13, 2017 at 7:23 PM, Jeff Janes wrote: > On Thu, Jul 13, 2017 at 1:15 AM, Michael Paquier > wrote: >> >> On Thu, Jul 13, 2017 at 5:26 AM, Jeff Janes wrote: >> > >> > I think that none of the recovery information functions >> > >> > (https://www.postgresql.org/docs/9.6/static/function

Re: [GENERAL] Monitoring of a hot standby with a largely idle master

2017-07-13 Thread Jeff Janes
On Thu, Jul 13, 2017 at 1:15 AM, Michael Paquier wrote: > On Thu, Jul 13, 2017 at 5:26 AM, Jeff Janes wrote: > > > > I think that none of the recovery information functions > > (https://www.postgresql.org/docs/9.6/static/functions-admin. > html#FUNCTIONS-RECOVERY-INFO-TABLE) > > can distinguish

Re: [GENERAL] Monitoring of a hot standby with a largely idle master

2017-07-13 Thread Michael Paquier
On Thu, Jul 13, 2017 at 5:26 AM, Jeff Janes wrote: > > I think that none of the recovery information functions > (https://www.postgresql.org/docs/9.6/static/functions-admin.html#FUNCTIONS-RECOVERY-INFO-TABLE) > can distinguish a hot standby which is connected to an idle master, versus > one which

[GENERAL] Monitoring of a hot standby with a largely idle master

2017-07-12 Thread Jeff Janes
I think that none of the recovery information functions ( https://www.postgresql.org/docs/9.6/static/functions-admin.html#FUNCTIONS-RECOVERY-INFO-TABLE) can distinguish a hot standby which is connected to an idle master, versus one which is disconnected. For example, because the master has crashed