Jasen Betts a écrit :
> On 2010-03-11, A B <gentosaker(at)gmail(dot)com> wrote:
>> 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.
In response to
pgsql-novice by date
|Next:||From: Didier Gasser-Morlay||Date: 2010-03-14 14:19:30|
|Subject: I need your thoughts ....|
|Previous:||From: Jasen Betts||Date: 2010-03-12 08:48:21|
|Subject: Re: Step back to previous state (a.k.a. undo)|