Re: Re: Vacuum of newly activated 8.3.12 standby receives warnings page xxx is uninitialized --- fixing

Mark Kirkwood <mark.kirkwood@catalyst.net.nz>

From: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
To: Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Cc: pitrtools@lists.commandprompt.com, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-12-30T22:11:43Z
Lists: pgsql-hackers
On 31/12/10 11:01, Heikki Linnakangas wrote:
> On 30.12.2010 10:55, Mark Kirkwood wrote:
>> Removing the offending
>>
>> --delete --exclude=backup_label
>>
>> options from the base backup step makes everything work properly again.
>
> I don't see why --delete would make any difference, but you shouldn't 
> exclude backup_label from the base backup. The backup label file is an 
> important part of the online backup, it cannot be recovered safely 
> without it.
>

Yes, you (and Robert) are entirely correct, I was confused in my 
understanding of the "--delete --exclude=backup_label" and thought it to 
mean "exclude the backup label from the delete". Yeah the --delete is 
harmless, it is the exclude backup_label that is causing the problem.

Note to all current Pitrtools users, this impacts you! We need to get a 
corrected version out soon I would think.

I note that this uninitialized pages with standbys has cropped up from 
time to time - I wonder if in most/all the cases folk were using Pitrtools?

regards

Mark