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

Re: some requests/questions .

From: Féliciano Matias <feliciano.matias_at_free.fr>
Date: 2002-07-13 00:47:20 CEST

Le ven 12/07/2002 à 14:48, Ben Collins-Sussman a écrit :
> Féliciano Matias <feliciano.matias@free.fr> writes:
> ----
>

>
> > Le ven 12/07/2002 à 07:41, Féliciano Matias a écrit :
> > > First, excuse my poor english.
> > >
> > > ** Can i do a hot dump (with svnadmin dump).
> > >
> >
> > I see a python script (tool/backup/hot-backup.py) that do the jobs by
> > doing some copy file. I prefer a real dump (svnadmin) that is more
> > portable/secure.
>
> As I said, 'svnadmin dump' is not for backups. It has nothing to do
> with the BSD 'dump' command that you would spool to a tape device.
> It's for data migration, and is very slow.
>
> 'cp' is for backups. What is un-portable.

un-portable :

This is un-portable between version of subversion. I see un thread here
about "Problem compiling r2092 in order to convert database". I don't
want to deal with such problem.

I use postgresql and i alwars do dump (dump in clear text). why ?
Here are release of postgresql that need a dump/restore for migration :
Release date: 2002-02-04 => 7.2
Release date: 2000-05-08 => 7.0
Release date: 1999-06-09 => 6.5
# 5 un-compatible binary formats in 2 year !
Release date: 1998-10-30 => 6.4
Release date: 1998-03-01 => 6.3
Release date: 1997-10-02 => 6.2
Release date: 1997-06-08 => 6.1
Release date: 1997-01-29 => 6.0

Image, you update a Redhat (or Suse, or ...) systeme based. Redhat only
provide one version of postgresql by release. Redhat 7.2 has postgresql
7.1. Redhat does not provide version 6.5 through 6.0 of postgresql for
user upgrading from Redhat 6.2, 6.0, ...

This is a big problem. A big problem only if you don't have dump but
only binary backup of your database.

> or insecure about 'cp'? Or
> python? This is how BerkeleyDB was designed to be backed up.
cp is definitely a secure tool.

If your data are in dump format of postgresql, it is more "safe" (my
english stay very poor). Your data is readable by most of the version of
postgresql. A dump of postgresql is sql command and easy to import in
oracle for exemple (with sed help).

When subversion can also use sql as db backend, i always use "svnadmin
dump". So if my computer which use svn with sql backend crash i can
import my backup in a computer which as svn only with bdb backend.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@subversion.tigris.org
For additional commands, e-mail: dev-help@subversion.tigris.org
Received on Sat Jul 13 00:49:39 2002

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

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