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

From Joe Conway
Subject Re: Automatically force zero_damaged_pages while InRecovery?
Date
Msg-id 3FC8F3F7.90701@joeconway.com
Whole thread Raw
In response to Automatically force zero_damaged_pages while InRecovery?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Automatically force zero_damaged_pages while InRecovery?  (Alvaro Herrera <alvherre@dcc.uchile.cl>)
List pgsql-hackers
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.

Joe



pgsql-hackers by date:

Previous
From: Randolf Richardson
Date:
Subject: Re: Day of week question
Next
From: Doug McNaught
Date:
Subject: Re: *sigh*