Dennis Allison wrote:
The ZODB is an append only file system so truncating works just fine.


Yup, but it's finding the location to truncate back to that's the interesting bit.

And that I'm lazy and really want to be able to do:

python rollback.py 2007-03-21 09:00

You can use any
of the standard tools (fsrecover, for example) to find the transactions
and their dates.

OK, so I guess that might be a good place to start...

The position in the file is part of the fsrecover
output.  Pick a date and truncate the Data.fs to the specified position
and you should be good to go. You'll want to kill all the index files
before you take the truncated file live to ensure they get rebuilt on restart.

Yup.

Alternatively you could use Tres' technique--just add a new disk to your system. For a few hundred dollars you could have an additional 400GB!

As Jens will testify, these are servers in a corporate data centre and the last time we tried to get more disk added it took several months and I'd wager that it cost a lot more than a few hunderd dollars ;-)

cheers,

Chris

--
Simplistix - Content Management, Zope & Python Consulting
           - http://www.simplistix.co.uk

_______________________________________________
For more information about ZODB, see the ZODB Wiki:
http://www.zope.org/Wikis/ZODB/

ZODB-Dev mailing list  -  ZODB-Dev@zope.org
http://mail.zope.org/mailman/listinfo/zodb-dev

Reply via email to