Re: [HACKERS] Automatically force zero_damaged_pages while InRecovery?
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 ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Automatically force zero_damaged_pages while InRecovery?
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. ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [HACKERS] Automatically force zero_damaged_pages while InRecovery?
Alvaro Herrera [EMAIL PROTECTED] writes: Yes, but is the error message going to stay verbatim? Maybe the category could be decreased ... The patch I proposed would still cause a WARNING to come out in the postmaster log. We could perhaps reduce it to a NOTICE if InRecovery is true, or have InRecovery add a DETAIL pointing out that this should be no problem (though the latter behavior couldn't be back-ported to 7.3 very readily). We'd not want to change the message wording in the 7.4 branch either. I think this is all a bit academic though, compared to the basic point of not failing ;-). In practice, any recovery from WAL is going to produce a bunch of scary-looking messages in the postmaster log. We're not likely to remove those messages, since they provide potentially critical debugging info if it fails to work. I'm not that concerned about making them less scary-looking ... regards, tom lane ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly