Tatsuo Ishii <t-ishii@sra.co.jp> writes:
>> No. It is not reasonable to expect the backup to allow you to recreate
>> any state occurring before the *end* of the backup process.
> I see your point. But is it reasonable? We cannot know when the backup
> process completes beforehand and that makes the archive log recovery
> less usefull in my opinion.
So? The backup will not let you recover states occurring before it
starts, either. I don't see the issue. Anyone using this in a
production situation will *always* have a prior backup and a continuous
WAL trail since the start of the prior backup. Whether the
synchronization point is the start time or end time of each new backup
isn't a hot issue for them --- at least it shouldn't be if they are
following appropriate procedures.
The only way I can see to make it work the other way is to dump the
entire contents of any to-be-deleted table into the WAL log before
deleting it. That is way too much overhead to be a reasonable tradeoff
for letting people think of the start time rather than end time of their
backups as the cutover point.
regards, tom lane
