[ZODB-Dev] Re: roll back filestorage zodb to a certain date?

Dieter Maurer dieter at handshake.de
Wed Mar 21 15:26:28 EDT 2007


Jim Fulton wrote at 2007-3-21 10:06 -0400:
> ...
>
>On Mar 21, 2007, at 9:59 AM, Tres Seaver wrote:
>
>> -----BEGIN PGP SIGNED MESSAGE-----
>> Hash: SHA1
>>
>> Jim Fulton wrote:
>>> On Mar 21, 2007, at 6:41 AM, Chris Withers wrote:
>>>
>>>> Hi All,
>>>>
>>>> Is there any existing method or script for rolling back a ZODB
>>>> (filestorage-backed in this case,
>>>
>>> Back end to what?
>>>
>>>
>>>> if that makes it easier) to a certain point in time?
>>>
>>> Do you actually want to modify the file? Or do you simply want to
>>> access it as of a particular time.
>>> There is already a mechanism for opening a file storage as of a
>>> particular time.
>>>
>>>
>>>> eg: Make this Data.fs as it was at 9am this morning
>>>>
>>>> If not, I'll be writing one, where should I add it to when I'm done?
[Jim]
>>> Before we talk about adding it anywhere, I'd like to see the
>>> semantics defined more clearly.

[Tres]
>> Chris could:
>>
>>   1. Open the existing file in time-travel mode (readonly, so that it
>>      loads no transactions later than the given point).  The 'stop'
>>      parameter to the FileStorage initializer is the one which
>>      triggers time-travel.
>>
>>   2. Open a new, writable filestorage.
>>
>>   3. Run 'copyTransactionsFrom' on the new storage, passing the old,
>>      and then close the storages.
>>
>>   4. Restart his Zope with the new storage.

[Jim]
>I wasn't asking about implementation.

[Dieter]
But, it is nice to know one (for the rare cases when one has to recover
from a catastrophic human error).

As such a functionality is only necessary in rare occasions,
I think, it need not be sophisticated.

-- 
Dieter


More information about the ZODB-Dev mailing list