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

From: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
To: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
Cc: pitrtools(at)lists(dot)commandprompt(dot)com, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Re: Vacuum of newly activated 8.3.12 standby receives warnings page xxx is uninitialized --- fixing
Date: 2010-12-30 22:11:43
Message-ID: 4D1D039F.7080605@catalyst.net.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Mark Kirkwood 2010-12-30 22:27:39 Re: Re: Vacuum of newly activated 8.3.12 standby receives warnings page xxx is uninitialized --- fixing
Previous Message Heikki Linnakangas 2010-12-30 22:01:06 Re: Re: Vacuum of newly activated 8.3.12 standby receives warnings page xxx is uninitialized --- fixing