Re: write ahead logging in standby (streaming replication) - Mailing list pgsql-hackers

From Tom Lane
Subject Re: write ahead logging in standby (streaming replication)
Date
Msg-id 14163.1257995016@sss.pgh.pa.us
Whole thread Raw
In response to write ahead logging in standby (streaming replication)  (Fujii Masao <masao.fujii@gmail.com>)
Responses Re: write ahead logging in standby (streaming replication)
List pgsql-hackers
Fujii Masao <masao.fujii@gmail.com> writes:
> Should the standby also have to follow the WAL rule during recovery?
> The current patch doesn't care about the write order of the data page
> and WAL in the standby. So, after both servers fail, restarting the
> ex-standby by itself might corrupt the data.

Surely the receiver should fsync the WAL itself to disk before
acknowledging it.  Assuming you've done that, I don't see any
corruption risk.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Robert Haas
Date:
Subject: Re: next CommitFest
Next
From: A.M.
Date:
Subject: Re: Listen / Notify rewrite