Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B619764FE79 for ; Wed, 15 Oct 2008 10:21:27 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 31931-09 for ; Wed, 15 Oct 2008 10:21:20 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id 3201B64FD91 for ; Wed, 15 Oct 2008 10:21:20 -0300 (ADT) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1Kq6JO-0008JV-JT for pgsql-performance@postgresql.org; Wed, 15 Oct 2008 13:21:14 +0000 Received: from lara.cc.fer.hr ([161.53.72.113]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 15 Oct 2008 13:21:14 +0000 Received: from ivoras by lara.cc.fer.hr with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 15 Oct 2008 13:21:14 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-performance@postgresql.org From: Ivan Voras Subject: Re: Backup strategies Date: Wed, 15 Oct 2008 15:21:12 +0200 Lines: 37 Message-ID: References: <48F4D693.9000304@lerner.co.il> <48F5BBFC.80404@krogh.cc> <48F5D6AE.3000601@lelarge.info> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="------------enigA6A24650D3A9BFFC3B677B65" X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: lara.cc.fer.hr User-Agent: Thunderbird 2.0.0.17 (X11/20080925) In-Reply-To: <48F5D6AE.3000601@lelarge.info> X-Enigmail-Version: 0.95.0 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200810/83 X-Sequence-Number: 31664 This is an OpenPGP/MIME signed message (RFC 2440 and 3156) --------------enigA6A24650D3A9BFFC3B677B65 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Guillaume Lelarge wrote: > Ivan Voras a =C3=A9crit : >> It looks like PostgreSQL freezes the state of the "data" directory in >> this case (and new data goes only to the transaction log - pg_xlog), >> which effectively creates an application-level snapshot. Good to know.= >=20 > Nope. Even files in data directory change. That's why the documentation= > warns against tools that emit errors for files that change during the c= opy. Ok, thanks. This is a bit off-topic, but if it's not how I imagine it, then how is it implemented? --------------enigA6A24650D3A9BFFC3B677B65 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFI9e5IldnAQVacBcgRAm6PAJ9v7GryxmHHcXVjJ3y4Iyx9zNK54QCg7jeQ ukF9bhrh8Z4Zq8zkotwT660= =W8TN -----END PGP SIGNATURE----- --------------enigA6A24650D3A9BFFC3B677B65--