From: Gregory Stark <stark@enterprisedb.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Koichi Suzuki <suzuki.koichi@oss.ntt.co.jp>
Cc: Simon Riggs <simon@2ndquadrant.com>
Cc: Toru SHIMOGAKI <shimogaki.toru@oss.ntt.co.jp>
Cc: Dan Gorman <dgorman@hi5.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: PITR Backups
Date: Mon, 25 Jun 2007 16:00:25 +0100
Message-ID: <87fy4guliu.fsf@oxford.xeocode.com> (raw)
In-Reply-To: <28289.1182781909@sss.pgh.pa.us>
References: <7E0807EE-B970-4869-A248-B838E42AD9EE@hi5.com>
<9761.1182472005@sss.pgh.pa.us>
<467B3459.9030808@oss.ntt.co.jp>
<1182509748.9276.178.camel@silverbirch.site>
<467F938F.1030708@oss.ntt.co.jp>
<28289.1182781909@sss.pgh.pa.us>
"Tom Lane" <tgl@sss.pgh.pa.us> writes:
> AFAIK, actually workable methods of this type depend on filesystem
> cooperation, and are able to produce coherent snapshots of the logical
> (not necessarily physical) filesystem content at a specific instant.
I think you need filesystem cooperation in order to provide access to the
snapshot somewhere. But the actual snapshotting is done at a very low level by
intercepting any block writes and stashing away the old version before writing
or alternately by noting the new version and redirecting any reads to the new
version.
I concur that anything that doesn't allow concurrent i/o while the
snapshotting is happening is worthless. It sounds like you're just dd'ing from
the device which is pretty much guaranteed not to work.
Even if Postgres didn't do any i/o there's nothing stopping the OS and
filesystem from issuing i/o.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: stark@enterprisedb.com, tgl@sss.pgh.pa.us, suzuki.koichi@oss.ntt.co.jp, simon@2ndquadrant.com, shimogaki.toru@oss.ntt.co.jp, dgorman@hi5.com
Subject: Re: PITR Backups
In-Reply-To: <87fy4guliu.fsf@oxford.xeocode.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox