Re: Enforcing that all WAL has been replayed after restoring from backup

From: Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Enforcing that all WAL has been replayed after restoring from backup
Date: 2011-08-09 15:22:05
Message-ID: 4E41509D.3090408@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 09.08.2011 18:20, Alvaro Herrera wrote:
> Excerpts from Heikki Linnakangas's message of mar ago 09 05:00:00 -0400 2011:
>
>> I think this is a nice additional safeguard to have, making streamed
>> backups more robust. I'd like to add this to 9.1, but it required an
>> extra field to be added to the control file, so it would force an
>> initdb. It's probably not worth that. Or, we could sneak in the extra
>> boolean field to some currently unused pad space in the ControlFile struct.
>
> How about making the new backup_label field optional? If absent, assume
> current behavior.

That's how I actually did it in the patch. However, the problem wrt.
requiring initdb is not the new field in backup_label, it's the new
field in the control file.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2011-08-09 15:25:27 Re: Compiler warnings with stringRelOpts (was WIP: Fast GiST index build)
Previous Message Alvaro Herrera 2011-08-09 15:20:33 Re: Enforcing that all WAL has been replayed after restoring from backup