Tatsuo Ishii <t-ishii@sra.co.jp> writes:
> Consider a scenario:
> (1) backup process starts (and records LSN)
> (2) DROP TABLE t1 starts
> (3) DROP TABLE t1 commits
> (4) backup process ends
> I think the database status should be able to go back to (1) using
> the archive log recovery. No?
No. It is not reasonable to expect the backup to allow you to recreate
any state occurring before the *end* of the backup process. After the
backup is complete, you can use the backup and the WAL to duplicate the
state of any later instant.
regards, tom lane