Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 5E6759FB24B for ; Tue, 9 Jan 2007 12:52:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-new, port 10024) with ESMTP id 50709-10 for ; Tue, 9 Jan 2007 12:52:27 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from coe.tamu.edu (edsun.coe.tamu.edu [165.91.232.6]) by postgresql.org (Postfix) with ESMTP id 2E6009FA3AC for ; Tue, 9 Jan 2007 12:52:27 -0400 (AST) Received: (from root@localhost) by coe.tamu.edu (8.11.7p2+Sun/8.12.11) id l09GoRC29447 for pgsql-admin@postgresql.org; Tue, 9 Jan 2007 10:50:27 -0600 (CST) Received: from coe.tamu.edu (coe.tamu.edu [165.91.232.6]) by coe.tamu.edu (8.11.7p2+Sun/8.12.11) with ESMTP id l09Gkgx29142; Tue, 9 Jan 2007 10:46:42 -0600 (CST) Date: Tue, 9 Jan 2007 10:46:42 -0600 (CST) From: "Ben K." To: Simon Riggs cc: pgsql-admin@postgresql.org Subject: Re: PITR recovery In-Reply-To: <1168360240.3951.289.camel@silverbirch.site> Message-ID: References: <1168097862.3655.249.camel@silverbirch.site> <1168273726.3951.202.camel@silverbirch.site> <1168360240.3951.289.camel@silverbirch.site> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: by AMaViS 0.3.12 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/78 X-Sequence-Number: 24234 > PITR doesn't go back in time. It only supports roll-forward from a prior > base backup using the logs, stopping at a predefined time/xid/endoflogs. > Going backwards using the logs is mostly impossible because the log > records don't hold enough info to un-erase things. > > It is theoretically possible to enhance the server to be able to rewind > the data in a table by uncommitting transactional changes, but again you > can't put back data that has been emoved by VACUUM. That feature would > be similar to flashback, but its more complex then it sounds at first > hearing. I wouldn't hold your breath while waiting for that. It was not that it's essential. Thanks for sharing the insight. Regards, Ben K. Developer http://benix.tamu.edu