Re: Step back to previous state (a.k.a. undo) - Mailing list pgsql-novice

From damien clochard
Subject Re: Step back to previous state (a.k.a. undo)
Date
Msg-id 4B9A22E6.3090302@dalibo.info
Whole thread Raw
In response to Re: Step back to previous state (a.k.a. undo)  (Jasen Betts <jasen@xnet.co.nz>)
List pgsql-novice
Jasen Betts a écrit :
> On 2010-03-11, A B <gentosaker@gmail.com> wrote:
>> Hello!
>>
>> Is it possible to tell a running postgres server to rememeber its
>> state at a certain timestamp, then  let clients access the database,
>> do what ever they want, then just roll back to the timestamp?
>
> not using just SQL commands.
>
> AIUI there are two options
>
> 1 > PITR ("point in time recovery")
>
> 2 > dump and restore
>
>

3 > There's a brand new project on pgFoundry called e-maj that aims to
"undo" the SQL activity. It's not ready for production, though.

http://pgfoundry.org/projects/emaj/

pgsql-novice by date:

Previous
From: Jasen Betts
Date:
Subject: Re: Step back to previous state (a.k.a. undo)
Next
From: Didier Gasser-Morlay
Date:
Subject: I need your thoughts ....