Skip site navigation (1) Skip section navigation (2)

Re: Step back to previous state (a.k.a. undo)

From: damien clochard <damien(at)dalibo(dot)info>
To: Jasen Betts <jasen(at)xnet(dot)co(dot)nz>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Step back to previous state (a.k.a. undo)
Date: 2010-03-12 11:17:58
Message-ID: 4B9A22E6.3090302@dalibo.info (view raw or flat)
Thread:
Lists: pgsql-novice
Jasen Betts a écrit :
> On 2010-03-11, A B <gentosaker(at)gmail(dot)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/

In response to

pgsql-novice by date

Next:From: Didier Gasser-MorlayDate: 2010-03-14 14:19:30
Subject: I need your thoughts ....
Previous:From: Jasen BettsDate: 2010-03-12 08:48:21
Subject: Re: Step back to previous state (a.k.a. undo)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group