"Jason L. Buberel" <jason(at)buberel(dot)org> writes:
> Instead, in order to achieve my goal I would have to restore to that
> backup, and rely on the contents of the archive_logs to have the
> recovery process return me to the selected xid PITR.
Correct.
> So is there any way to 'trick' or force the server to forget what it
> thinks 'now' is and instead to step back to the selected xid and make
> that the new version of 'now'?
No. As an example, would you expect such a trick to reverse the effects
of a DROP TABLE? Or even just a single DELETE? That would mean we
could *never* free any storage.
regards, tom lane