Monitoring of a hot standby with a largely idle master

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Monitoring of a hot standby with a largely idle master
Date: 2017-07-13 03:26:56
Message-ID: CAMkU=1w0er2QZYwirYRsE=8b+d1+24xoq_SqsBr1CO=oT19BOA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-general

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, or
someone has changed the firewall rules.

Is there a way to monitor from SQL the last time the standby was able to
contact the master and initiate streaming with it? Other than trying to
write a function that parses it out of pg_log?

Cheers,

Jeff

Responses

Browse pgsql-general by date

  From Date Subject
Next Message rihad 2017-07-13 05:41:42 Re: Changing collate & ctype for an existing database
Previous Message Tom Lane 2017-07-12 19:25:56 Re: Changing collate & ctype for an existing database