Re: Measuring replication lag time - Mailing list pgsql-general

From Greg Williamson
Subject Re: Measuring replication lag time
Date
Msg-id 1329940686.26787.YahooMailNeo@web46116.mail.sp1.yahoo.com
Whole thread Raw
In response to Measuring replication lag time  (Stuart Bishop <stuart@stuartbishop.net>)
Responses Re: Measuring replication lag time
List pgsql-general
Stuart Bishop shaped the aether to ask:

> Hi.
>
> I need to measure how far in the past a hot standby is, async
> streaming replication.
>


Not sure if this will help, but we are using repmgr <https://github.com/greg2ndQuadrant/repmgr>; it sets up a
monitoringschema which we poll )see the "Monitoring and Testing" section ... study their source code some and see how
theycome up with lag times. 

HTH,

Greg WiIliamson
DBA
Powerreviews dot com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Default PostgreSQL server encoding - Change to unicode (utf8)
Next
From: Alexander Farber
Date:
Subject: Counting different strings (OK%, FB%) in same table, grouped by week number