Re: streaming replication breaks horribly if master crashes - Mailing list pgsql-hackers

From Tom Lane
Subject Re: streaming replication breaks horribly if master crashes
Date
Msg-id 16250.1276792993@sss.pgh.pa.us
Whole thread Raw
In response to Re: streaming replication breaks horribly if master crashes  (Fujii Masao <masao.fujii@gmail.com>)
List pgsql-hackers
Fujii Masao <masao.fujii@gmail.com> writes:
> On Thu, Jun 17, 2010 at 5:26 AM, Robert Haas <robertmhaas@gmail.com> wrote:
>> The real problem here is that we're sending records to the slave which
>> might cease to exist on the master if it unexpectedly reboots. �I
>> believe that what we need to do is make sure that the master only
>> sends WAL it has already fsync'd (Tom suggested on another thread that
>> this might be necessary, and I think it's now clear that it is 100%
>> necessary).

> The attached patch changes walsender so that it always sends WAL up to
> LogwrtResult.Flush instead of LogwrtResult.Write.

Applied, along with some minor comment improvements of my own.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: Should the JSON datatype be a specialization of text?
Next
From: "David E. Wheeler"
Date:
Subject: Re: hstore ==> and deprecate =>