Re: recovery_target_time ignored or recovery always recovers to end of WAL

"Jason L. Buberel" <jason@buberel.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