Re: pgsql: rm_cleanup functions need to be allowed to write WAL entries. - Mailing list pgsql-committers

From Simon Riggs
Subject Re: pgsql: rm_cleanup functions need to be allowed to write WAL entries.
Date
Msg-id 1249852952.4839.496.camel@ebony.2ndQuadrant
Whole thread Raw
In response to Re: pgsql: rm_cleanup functions need to be allowed to write WAL entries.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pgsql: rm_cleanup functions need to be allowed to write WAL entries.
List pgsql-committers
On Sun, 2009-08-09 at 11:41 -0400, Tom Lane wrote:
> Simon Riggs <simon@2ndQuadrant.com> writes:
> > I want to move in the direction of having two cleanup routines, one
> > executed before recovery ends and one done afterwards, so it can write
> > WAL. Perhaps these would be called rm_makesafe() and rm_repair(). Rough
> > thinking at this stage.
>
> > The rm_repair() would execute in a separate process once we're up.
>
> Er, what's the point of that?

Rebuilding damaged indexes automatically, rather than barfing. I regard
that as a long term extension of crash recovery to bring a database back
to a usable state.

--
 Simon Riggs           www.2ndQuadrant.com


pgsql-committers by date:

Previous
From: bmomjian@pgfoundry.org (User Bmomjian)
Date:
Subject: pg-migrator - pg_migrator: Clarify which restrictions are 8.3 -> 8.4
Next
From: Tom Lane
Date:
Subject: Re: pgsql: rm_cleanup functions need to be allowed to write WAL entries.