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