Postgres Pro
Downloads
Home   >   mailing lists

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

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

From
A B
Date:
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?

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

From
Jasen Betts
Date:
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

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

From
damien clochard
Date:
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/