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