Re: time-delayed standbys

Greg Stark <gsstark@mit.edu> writes:
> On Wed, Apr 20, 2011 at 2:19 PM, Robert Haas <robertmhaas@gmail.com> wrote:
>> How would we keep track of the most recent timestamp received from the
>> master without replaying the WAL records?

> Well as we receive them we would have to peek at them to see the time.
> Or we could have the master send its time to the slave as I believe
> Tom has already proposed in the past but I believe didn't choose to
> do?

My idea of how to manage it would be to have walreceiver explicitly
track the clock difference from the master, which it can do since
walsender puts its current time into every message header.  You can use
the slave's clock for comparisons so long as you add the appropriate
offset.  (The theory here is that the skew won't change very fast ...)
        regards, tom lane