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

From Simon Riggs
Subject Re: BUG #4879: bgwriter fails to fsync the file in recovery mode
Date
Msg-id 1245962346.4038.214.camel@ebony.2ndQuadrant
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>)
Responses Re: BUG #4879: bgwriter fails to fsync the file in recovery mode
List pgsql-bugs
On Thu, 2009-06-25 at 15:10 -0400, Tom Lane wrote:

> So to summarize the state of play, it seems
> we have these issues:
>
> * need to delete startup process's local pendingOpsTable once bgwriter
> is launched, so that requests go to bgwriter instead

Need to ensure that fsync requests are directed to the process that will
act on the fsync requests.

> * need to push end-of-recovery checkpoint into bgwriter

That's probably the easiest thing to do, but the issue is that we must
fsync all files mentioned in the pendingOpsTable in *any* process that
has been accumulating such requests.

> * need to do something about IsRecovery tests that will now be executed
> in bgwriter

Yes

> * need to fix mistaken code in FinishPreparedTransaction

Yes

--
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support

pgsql-bugs by date:

Previous
From: "Dustin Parker"
Date:
Subject: BUG #4882: One-click installer crashes with certain service account passwords
Next
From: Heikki Linnakangas
Date:
Subject: Re: BUG #4879: bgwriter fails to fsync the file in recovery mode