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

Поиск
Список
Период
Сортировка
Искать

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

От:
damien clochard <damien@dalibo.info>
Дата:
Jasen Betts a écrit :
> On 2010-03-11, A B  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/

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

От:
A B <gentosaker@gmail.com>
Дата:
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)

От:
Jasen Betts <jasen@xnet.co.nz>
Дата:
On 2010-03-11, A B  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
FAQ