Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group