Received: from localhost (unknown [200.46.204.184])
	by postgresql.org (Postfix) with ESMTP id D3BE12E2FFA;
	Thu, 31 Jan 2008 10:36:10 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024)
	with ESMTP id 02245-02; Thu, 31 Jan 2008 10:35:49 -0400 (AST)
Received: from svana.org (svana.org [203.190.233.187])
	by postgresql.org (Postfix) with ESMTP id 001FE2E2DD2;
	Thu, 31 Jan 2008 10:35:01 -0400 (AST)
Received: from kleptog by svana.org with local (Exim 4.50)
	id 1JKaUP-0007JC-Sv; Fri, 01 Feb 2008 01:34:05 +1100
Date: Thu, 31 Jan 2008 15:34:05 +0100
From: Martijn van Oosterhout <kleptog@svana.org>
To: Simon Riggs <simon@2ndquadrant.com>
Cc: Chander Ganesan <chander@otg-nc.com>,
	Phillip Smith <phillip.smith@weatherbeeta.com.au>,
	'Dominic Carlucci' <carlucci@cae.com>, pgsql-general@postgresql.org,
	pgsql-admin@postgresql.org, carlucci@cae.ca
Subject: Re: [GENERAL] Backup
Message-ID: <20080131143405.GC21660@svana.org>
Reply-To: Martijn van Oosterhout <kleptog@svana.org>
Mail-Followup-To: Simon Riggs <simon@2ndquadrant.com>,
	Chander Ganesan <chander@otg-nc.com>,
	Phillip Smith <phillip.smith@weatherbeeta.com.au>,
	'Dominic Carlucci' <carlucci@cae.com>, pgsql-general@postgresql.org,
	pgsql-admin@postgresql.org, carlucci@cae.ca
References: <00a201c85ee9$fbd1ca00$9b0014ac@wbaus090>
	<1201252875.4257.387.camel@ebony.site>
	<47A1BD51.3030902@otg-nc.com>
	<1201786128.4453.287.camel@ebony.site>
Mime-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="R+My9LyyhiUvIEro"
Content-Disposition: inline
In-Reply-To: <1201786128.4453.287.camel@ebony.site>
X-PGP-Key-ID: Length=1024; ID=0x6F0B424C
X-PGP-Key-Fingerprint: 34A8 8EAC F902 8C8D CA72  DCC7 201E DB34 6F0B 424C
User-Agent: Mutt/1.5.9i
X-SA-Exim-Connect-IP: <locally generated>
X-SA-Exim-Mail-From: kleptog@svana.org
X-SA-Exim-Scanned: No (on svana.org); SAEximRunCond expanded to false
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200801/292
X-Sequence-Number: 28066


--R+My9LyyhiUvIEro
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Thu, Jan 31, 2008 at 01:28:48PM +0000, Simon Riggs wrote:
> That sentence has no place in any discussion about "backup" because the
> risk is not just a few transactions, it is a corrupt and inconsistent
> database from which both old and new data would be inaccessible.

Hmm? I thought the whole point of a filesystem snapshot was that it's
the same as if the system crashed. And I was fairly sure we could
recover from that...

Have a nice day,
--=20
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolutio=
n inevitable.
>  -- John F Kennedy

--R+My9LyyhiUvIEro
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature
Content-Disposition: inline

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFHodxdIB7bNG8LQkwRAjuoAJ9aYCfZu+x/fpYBY701c58BR3ZYrgCeN83Z
ohVT+p0OLrxDwV8pJvuy4zk=
=Dhnl
-----END PGP SIGNATURE-----

--R+My9LyyhiUvIEro--