Re: Automatically force zero_damaged_pages while InRecovery? - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Automatically force zero_damaged_pages while InRecovery?
Date
Msg-id 20031129194603.GA16671@dcc.uchile.cl
Whole thread Raw
In response to Re: Automatically force zero_damaged_pages while InRecovery?  (Joe Conway <mail@joeconway.com>)
Responses Re: Automatically force zero_damaged_pages while InRecovery?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Sat, Nov 29, 2003 at 11:31:03AM -0800, Joe Conway wrote:
> Tom Lane wrote:
> >This failure is actually entirely pointless, because (AFAIK) any page
> >that is brought in during WAL recovery is going to be overwritten in
> >toto from the WAL log.  So it would be safe to run WAL recovery with
> >zero_damaged_pages enabled.  Rather than expecting DBAs to think of that
> >under the stress of a crashed-database situation, I propose that we do
> >it for them:
> 
> Sounds like a good idea to me.

Yes, but is the error message going to stay verbatim?  Maybe the
category could be decreased ...

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"Everybody understands Mickey Mouse. Few understand Hermann Hesse.
Hardly anybody understands Einstein. And nobody understands Emperor Norton."


pgsql-hackers by date:

Previous
From: "Marc G. Fournier"
Date:
Subject: 7.3.5 to be released this week ...
Next
From: Tom Lane
Date:
Subject: Re: Automatically force zero_damaged_pages while InRecovery?