Re: time-delayed standbys - Mailing list pgsql-hackers

From Tom Lane
Subject Re: time-delayed standbys
Date
Msg-id 26404.1303310491@sss.pgh.pa.us
Whole thread Raw
In response to Re: time-delayed standbys  (Greg Stark <gsstark@mit.edu>)
Responses Re: time-delayed standbys  (Greg Stark <gsstark@mit.edu>)
List pgsql-hackers
Greg Stark <gsstark@mit.edu> writes:
> Ah, so we did put the master's clock in every message?

Yes, we did.

> Then this
> should be simple, no? Just compare the master's timestamp from the
> record to the last master's clock seen in the messages. That sounds
> equivalent but a lot safer than trying to keep a conversion between
> them.

Well, the question is what happens after you stop receiving master
messages.  If you don't make use of the slave's clock somehow,
application of WAL will stop dead in the water, which seems unlikely
to be what's wanted.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: REINDEX vs broken HOT chains, redux
Next
From: Noah Misch
Date:
Subject: Re: Typed table DDL loose ends