Re: Option to undo last update on table. - Mailing list pgsql-general

From Alan Hodgson
Subject Re: Option to undo last update on table.
Date
Msg-id 200702151038.53156@hal.medialogik.com
Whole thread Raw
In response to Re: Option to undo last update on table.  (RPK <rohitprakash123@indiatimes.com>)
List pgsql-general
On Thursday 15 February 2007 10:30, RPK <rohitprakash123@indiatimes.com>
wrote:
> Rollback will just rollback to last step (if I am right), but is there a
> way to bring the table to a certain TimeStamp.

You can use a PITR backup to restore a fresh cluster to a time just before
your update.  If you are not running PITR backups, then no.

--
"The power of the executive to cast a man into prison without formulating
any charge known to the law, and particularly to deny him the judgment of
his peers, is in the highest degree odious, and the foundation of all
totalitarian government whether Nazi or Communist." -- Winston Churchill


pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: Stored Procedure examples
Next
From: Bruno Wolff III
Date:
Subject: Re: Recover anything from dropped database?