[svn.haxx.se] · SVN Dev · SVN Users · SVN Org · TSVN Dev · TSVN Users · Subclipse Dev · Subclipse Users · this month's index

Re: Subversion DB administration

From: Blair Zajac <blair_at_orcaware.com>
Date: 2007-11-07 15:58:32 CET

Ryan Schmidt wrote:
>
> On Nov 5, 2007, at 11:53, Hervť MALEVILLE wrote:
>
>> Iím new to SVN (working on Windows platforms, Visual studio 2005). Iím
>> a little bit worried about the DB system (Berkeley) embedded into SVN.
>> Does a simple backup/restore process available? Is this DB system
>> enough reliable? My network support team only work with MS SQL Server.
>> Could this be a problem if we need to execute any maintenance task?
>> Having any experience about such a case?
>
>
> The default repository format in Subversion 1.2.0 and later is no longer
> BerkeleyDB, but FSFS, which doesn't have these problems.
>
> BDB is considered very reliable, but can be harder to maintain than
> FSFS. If you don't know what you're doing, stick with FSFS, which is
> also very reliable. For most people, FSFS should work great.

Even if you use FSFS, you still need a Subversion aware backup of it if people
are doing commits into it at the same time, otherwise the restore may not be an
internally consistent repository.

So regardless of BDB or FSFS, you need to use svnadmin dump or this tool, which
I recommend:

http://svn.collab.net/repos/svn/trunk/tools/backup/hot-backup.py.in

Regards,
Blair

-- 
Blair Zajac, Ph.D.
CTO, OrcaWare Technologies
<blair@orcaware.com>
Subversion training, consulting and support
http://www.orcaware.com/svn/
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@subversion.tigris.org
For additional commands, e-mail: users-help@subversion.tigris.org
Received on Wed Nov 7 15:59:12 2007

This is an archived mail posted to the Subversion Users mailing list.

This site is subject to the Apache Privacy Policy and the Apache Public Forum Archive Policy.