On Thu, Feb 23, 2012 at 2:58 AM, Greg Williamson <gwilliamso...@yahoo.com> 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 > <https://github.com/greg2ndQuadrant/repmgr>; it sets up a monitoring schema > which we poll )see the "Monitoring and Testing" section ... study their > source code some and see how they come up with lag times.
Might help indeed. My existing solution already has a small daemon (I can't always query the Slony-I sl_status view fast enough for load balancing web requests, so I maintain a cache). But repmgr seems to cover other work I need to do to keep ops happy so something for me to look closer at. -- Stuart Bishop <stu...@stuartbishop.net> http://www.stuartbishop.net/ -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
