Re: BUG #4879: bgwriter fails to fsync the file in recovery mode - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #4879: bgwriter fails to fsync the file in recovery mode
Date
Msg-id 20090626155751.GC5013@alvh.no-ip.org
Whole thread Raw
In response to Re: BUG #4879: bgwriter fails to fsync the file in recovery mode  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tom Lane escribió:
> I wrote:
> > Hmm ... this doesn't really feel cleaner to me, although I'm not sure
> > why not.
>
> Oh, I thought of a more concrete point: InRecovery is inherently a
> system-wide state, but XLogInsertAllowed is *not*.  While we write
> the EOR checkpoint, we really want only the bgwriter to be authorized
> to write WAL, but the scheme you propose would effectively authorize
> all processes during that window.

BTW one of the problems of the block-CRC patch was that we needed to
emit WAL records for hint bit states set during shutdown, as buffers
were flushed out, which obviously caused that error message to show up.
Due to another more serious problem I didn't investigate the solution to
this one, but it looks like it would be easy to set XLogInsertAllowed to
true while flushing buffers.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-bugs by date:

Previous
From: "stalker"
Date:
Subject: BUG #4888: Removed brackets from Check Constraints expressions
Next
From: Tom Lane
Date:
Subject: Re: BUG #4888: Removed brackets from Check Constraints expressions