Re: PITR Backups - Mailing list pgsql-performance

From Gregory Stark
Subject Re: PITR Backups
Date
Msg-id 87645gngyp.fsf@oxford.xeocode.com
Whole thread Raw
In response to Re: PITR Backups  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-performance
>> So, if any data is written during taking snapshot, we can't assurance data
>> correctness *strictly* .

That sounds nothing like what I've heard called a "snapshot" before. Some
"filesystems" which aren't really filesystems but are also storage layer
drivers like Veritas (and ZFS?) allow you to take a snapshot which they
guarantee is atomic. You can do them while you have concurrent i/o and be sure
to get a single consistent view of the filesystem.

If you're just copying blocks from a device without any atomic snapshot
guarantee then you're going to get garbage. Even in Postgres wasn't writing
anything the OS might still choose to flush blocks during that time, possibly
not even Postgres data blocks but filesystem meta-information blocks.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


pgsql-performance by date:

Previous
From: Rainer Bauer
Date:
Subject: Re: Data transfer very slow when connected via DSL
Next
From: Dimitri
Date:
Subject: Re: Data transfer very slow when connected via DSL