Re: Enforcing that all WAL has been replayed after restoring from backup - Mailing list pgsql-hackers

From Heikki Linnakangas
Subject Re: Enforcing that all WAL has been replayed after restoring from backup
Date
Msg-id 4E426119.10707@enterprisedb.com
Whole thread Raw
In response to Re: Enforcing that all WAL has been replayed after restoring from backup  (Magnus Hagander <magnus@hagander.net>)
Responses Re: Enforcing that all WAL has been replayed after restoring from backup
List pgsql-hackers
On 10.08.2011 12:29, Magnus Hagander wrote:
> On Tue, Aug 9, 2011 at 18:07, Tom Lane<tgl@sss.pgh.pa.us>  wrote:
>> Heikki Linnakangas<heikki.linnakangas@enterprisedb.com>  writes:
>>> On 09.08.2011 18:20, Alvaro Herrera wrote:
>>>> 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.
>>
>> Yeah.  I think it's too late to be fooling with pg_control for 9.1.
>> Just fix it in HEAD.
>
> Should we add a note to the documentation of pg_basebackup in 9.1
> telling people to take care about the failure case?

Something like "Note: if you abort the backup before it's finished, the 
backup won't be valid" ? That seems pretty obvious to me, hardly worth 
documenting.

> Or add a signal
> handler in the pg_basebackup client emitting a warning about it?

We don't have such a signal handler pg_dump either. I don't think we 
should add it.

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


pgsql-hackers by date:

Previous
From: Alexander Korotkov
Date:
Subject: Re: WIP: Fast GiST index build
Next
From: Magnus Hagander
Date:
Subject: Re: Enforcing that all WAL has been replayed after restoring from backup