Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeff Janes
Subject [GENERAL] Monitoring of a hot standby with a largely idle master
Date
Msg-id CAMkU=1w0er2QZYwirYRsE=8b+d1+24xoq_SqsBr1CO=oT19BOA@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Monitoring of a hot standby with a largely idle master  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-general
Tree view

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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: [GENERAL] Changing collate & ctype for an existing database
Next
From: rihad
Date:
Subject: Re: [GENERAL] Changing collate & ctype for an existing database