monitoring replicatgion : lag calculation

From: Ben Ciceron <ben(at)triggit(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: monitoring replicatgion : lag calculation
Date: 2011-09-12 17:04:07
Message-ID: CAOsHk6HSdg8wGHO6uX28GPn68crmwf6kDiDeOO=ymbF6c5DOGA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

hello,

question about WAL on pg 9.0 :

the doc at http://www.postgresql.org/docs/9.1/static/warm-standby.html#SYNCHRONOUS-REPLICATION
(section 25.2.5.2. Monitoring) says:

You can calculate this lag by comparing the current WAL write
location on the primary with the last WAL location received by the
standby.

but the WAL values i get are not 177/13C4E158 , 177/13C52BC0 so how to
calculate the lag ? should i apply a basic hex conversion first ?

Cheers,
Ben-

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lonni J Friedman 2011-09-12 17:41:50 Re: monitoring replicatgion : lag calculation
Previous Message Craig Ringer 2011-09-12 15:26:58 Re: Best procedure for restricted access