Skip site navigation (1) Skip section navigation (2)

Re: PITR Backups

From: Toru SHIMOGAKI <shimogaki(dot)toru(at)oss(dot)ntt(dot)co(dot)jp>
To: Steve Atkins <steve(at)blighty(dot)com>
Cc: PostgreSQL Performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: PITR Backups
Date: 2007-06-22 07:30:17
Message-ID: 467B7A89.3080300@oss.ntt.co.jp (view raw or flat)
Thread:
Lists: pgsql-performance
Steve Atkins wrote:

>> - When we take a PITR base backup with hardware level snapshot operation
>>   (not filesystem level) which a lot of storage vender provide, the 
>> backup data
>>   can be corrupted as Dan said. During recovery we can't even read it,
>>   especially if meta-data was corrupted.
> 
> I can't see any explanation for how this could happen, other
> than your hardware vendor is lying about snapshot ability.

All of the hardware vendors I asked always said:

  "The hardware level snapshot has nothing to do with filesystem condition and 
of course with what data has been written from operating system chache to the 
hard disk platter. It just copies byte data on storage to the other volume.

So, if any data is written during taking snapshot, we can't assurance data 
correctness *strictly* .

In Oracle, no table data is written between BEGIN BACKUP and END BACKUP, and it 
is not a problem REDO is written..."

I'd like to know the correct information if the explanation has any mistakes, or 
a good way to avoid the probrem.

I think there are users who want to migrate Oracle to PostgreSQL but can't 
because of the problem as above.


Best regards,

-- 
Toru SHIMOGAKI<shimogaki(dot)toru(at)oss(dot)ntt(dot)co(dot)jp>
NTT Open Source Software Center


In response to

Responses

pgsql-performance by date

Next:From: Toru SHIMOGAKIDate: 2007-06-22 07:41:24
Subject: Re: PITR Backups
Previous:From: Greg SmithDate: 2007-06-22 06:32:00
Subject: Re: PostgreSQL Configuration Tool for Dummies

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group