From owner-freebsd-stable@FreeBSD.ORG Thu Mar 26 15:11:01 2009 Return-Path: Delivered-To: freebsd-stable@freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34]) by hub.freebsd.org (Postfix) with ESMTP id ACBFA1065670; Thu, 26 Mar 2009 15:11:01 +0000 (UTC) (envelope-from scode@hyperion.scode.org) Received: from hyperion.scode.org (cl-1361.ams-04.nl.sixxs.net [IPv6:2001:960:2:550::2]) by mx1.freebsd.org (Postfix) with ESMTP id 65A7D8FC0C; Thu, 26 Mar 2009 15:11:01 +0000 (UTC) (envelope-from scode@hyperion.scode.org) Received: by hyperion.scode.org (Postfix, from userid 1001) id 95D4323C4E8; Thu, 26 Mar 2009 16:11:00 +0100 (CET) Date: Thu, 26 Mar 2009 16:11:00 +0100 From: Peter Schuller To: Karl Denninger Message-ID: <20090326151100.GA46864@hyperion.scode.org> References: <200903251820.54749.doconnor@gsoft.com.au> <200903251925.36108.doconnor@gsoft.com.au> <3.0.1.32.20090325072137.00ee6b48@sage-american.com> <3.0.1.32.20090326065337.00f081e0@sage-american.com> <3.0.1.32.20090326070807.00f081e0@sage-american.com> <200903261331.n2QDVd4b038485@lava.sentex.ca> <20090326140131.GA45201@hyperion.scode.org> <49CB8E74.9090508@denninger.net> <20090326145230.GC46345@hyperion.scode.org> <49CB97CD.2010303@denninger.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="TB36FDmn/VVEgNH/" Content-Disposition: inline In-Reply-To: <49CB97CD.2010303@denninger.net> User-Agent: Mutt/1.5.19 (2009-01-05) Cc: "Jack L. Stone" , freebsd-stable@freebsd.org, fs@freebsd.org Subject: Re: support quality (Re: dump | restore fails: unknown tape headertype 1853384566) X-BeenThere: freebsd-stable@freebsd.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Production branch of FreeBSD source code List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 26 Mar 2009 15:11:04 -0000 --TB36FDmn/VVEgNH/ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable > To add to this what SHOULD (ha!) work is to dump the database partition= =20 > FIRST and THEN dump the Transaction Log partition. Depending on how the database works; specifically when old data in the log may or may not be expunged. You could do this with PostgreSQL by using it's PITR support for example. But to the extent that you have a log which is only supposed to be used for internal reasons (such as with pg by default), you'd likely be in trouble anyway unless you had a specific reason to know that it is safe. > As always any backup scheme has to be TESTED so you can prove to your=20 > own satisfaction that it is RESTORABLE. I can't tell you how many=20 > business clients I have run into (and not only on Unix machines) that=20 > have wind up with lots of backups and NONE of them can be restored -=20 > because they never TESTED their backup strategy. Very true, but it is equally dangerous to rely on testing *only*; a backup system can be very very broken yet appear to work during testing, either because backups only break sometimes or because they break in ways that do not obviously and immediately blow up in your face. --=20 / Peter Schuller PGP userID: 0xE9758B7D or 'Peter Schuller ' Key retrieval: Send an E-Mail to getpgpkey@scode.org E-Mail: peter.schuller@infidyne.com Web: http://www.scode.org --TB36FDmn/VVEgNH/ Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.11 (FreeBSD) iEYEARECAAYFAknLmwMACgkQDNor2+l1i31jFQCfQ1YTYyriN8KwFSkAMrWvNTQo m6MAn1Mq0krTUayQbZt6oHjFbqHb5JMA =NlCs -----END PGP SIGNATURE----- --TB36FDmn/VVEgNH/--