Re: [GENERAL] Measuring replication lag time

2012-02-24 Thread Samba
> Comparing "pg_controldata" output on prod and standby might help you with > this. > We do use this approach and it is pretty reliable and gives time lag up to the granularity of checkpoint_timeout. On Thu, Feb 23, 2012 at 11:51 AM, Stuart Bishop wrote: > On Thu, Feb 23, 2012 at 2:58 AM, Greg

Re: [GENERAL] Measuring replication lag time

2012-02-22 Thread Stuart Bishop
On Thu, Feb 23, 2012 at 2:58 AM, Greg Williamson wrote: > 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 >

Re: [GENERAL] Measuring replication lag time

2012-02-22 Thread Greg Williamson
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 ; it sets up a monitoring schema which we poll )see the "M

Re: [GENERAL] Measuring replication lag time

2012-02-22 Thread Venkat Balaji
On Wed, Feb 22, 2012 at 5:40 PM, Stuart Bishop wrote: Hi. > > I need to measure how far in the past a hot standby is, async > streaming replication. > > On the Hot Standby, "select > age(current_timestamp,pg_last_xact_replay_timestamp())" gets me this > (or close enough for my purposes - I underst