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

From Dimitri Fontaine
Subject Re: Enforcing that all WAL has been replayed after restoring from backup
Date
Msg-id m2fwl672v0.fsf@2ndQuadrant.fr
Whole thread Raw
In response to Re: Enforcing that all WAL has been replayed after restoring from backup  (Magnus Hagander <magnus@hagander.net>)
List pgsql-hackers
Magnus Hagander <magnus@hagander.net> writes:
>>> 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.
>
> Hmm. I guess an aborted pg_dump will also "look ok but actually be
> corrupt" (or incomplete). Good point.

What about having the signal handler corrupt the backup by adding some
garbage into it?  Now the failure case is obvious…

Regards,
--
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support


pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Inserting heap tuples in bulk in COPY
Next
From: Simon Riggs
Date:
Subject: Re: Inserting heap tuples in bulk in COPY