couchdb-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Paul Davis <>
Subject Re: Inability to back up and restore properly
Date Tue, 07 Apr 2009 16:00:55 GMT
On Tue, Apr 7, 2009 at 10:42 AM, Nils Breunese <> wrote:
> Jeff Hinrichs - DM&T wrote:
>> What is the proper way to backup and restore a couchdb?  I mean a real
>> proper dump/load cycle.
>> couchdb doesn't provide a way to do a proper dump/reload cycle which
>> leaves
>> us to try and write our own.  However, if you dump a document like
>> {'_id':'foo',''_rev':'2-xyz',...}
>> There is not a single way that I can find to load an empty database and
>> recreate that same record.  If you put the
>> {'_id':'foo',''_rev':'2-xyz',...}, you get
>> {'_id':'foo',''_rev':'3-mno',...},  which is not the same as
>> {'_id':'foo',''_rev':'2-xyz',...}.
>> In some use cases it is necessary to be able to restore data to the way it
>> was at a point in time.  Sometimes for logic reasons, some times for error
>> recovery and debugging and some times for legal reasons.  The seemingly
>> only
>> way possible to do that is to bring up another couchdb instance and
>> replicate to it.  However, that is a bit problematic for normal long term
>> storage methodologies.
>> What is the API I should be using?   If no such api exists, is it an
>> oversight or just a matter of resources?  There should be a way to load
>> data
>> into couch and have couchdb just accept it, keeping the _rev information
>> that is passed.  I am not proposing to change the mode of operation, but
>> to
>> create a new one.  Even better would be to have couchdb do a
>> /database/_dump
>> that streams out documents and a post /database/_load with the posted file
>> from the /database/_dump.
>> so that you have some couchdb database foo in state 'A', you dump, then
>> create database bar, and load the dump from foo and when the process is
>> finished, a replication from foo state 'A' to bar results in
>> {"start_time":"Tue, 07 Apr 2009 03:02:16 GMT","end_time":"Tue, 07 Apr 2009
>> 03:02:16
>> GMT","start_last_seq":0,"end_last_seq":100,"missing_checked":100,"missing_found":0,"docs_read":0,"docs_written":0,"doc_write_failures":0}
> AFAIK you can just copy (or rsync) the database files, even with CouchDB
> running.
> Nils Breunese.

I forgot to mention that Nils is right as well with the caveat that
you need to make sure you're copying databases between binary file
compatible versions of CouchDB.

View raw message