Re: Automatically force zero_damaged_pages while InRecovery?

From: Joe Conway <mail(at)joeconway(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Automatically force zero_damaged_pages while InRecovery?
Date: 2003-11-29 19:31:03
Message-ID: 3FC8F3F7.90701@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Doug McNaught 2003-11-29 19:39:58 Re: *sigh*
Previous Message Tom Lane 2003-11-29 18:37:32 Automatically force zero_damaged_pages while InRecovery?