Re: several questions about pg_dumpall, pg_start_backup, pg_basebackup and WAL - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: several questions about pg_dumpall, pg_start_backup, pg_basebackup and WAL
Date
Msg-id 1377631895.15061.YahooMailNeo@web162901.mail.bf1.yahoo.com
Whole thread Raw
In response to Re: several questions about pg_dumpall, pg_start_backup, pg_basebackup and WAL  (Patrick Dung <patrick_dkt@yahoo.com.hk>)
Responses Re: several questions about pg_dumpall, pg_start_backup, pg_basebackup and WAL
List pgsql-admin
Patrick Dung <patrick_dkt@yahoo.com.hk> wrote:
> Albe Laurenz <laurenz.albe@wien.gv.at>
>> Patrick Dung wrote:

>>> It is possible that there is file changes (added or file size
>>> changed) between the pg_start_backup and pg_stop_backup.
>>
>> Yes.
>>
>>> Is the backup consistent?
>>
>> The tar or snapshot itself will not be consistent, it will have
>> to be recovered at least until the end on the online backup.
>
> I should ask: is the backup crash consistent?

PITR restore procedures will use the crash recovery mechanism to
make the database consistent, if that's what you mean.

> Which means it is consistent at the time that the pg_start_backup
> is run.

No.  It will be consistent with the time that pg_stop_backup was
run, or any later point in time that you choose, as long as you
have WAL to that point in time.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-admin by date:

Previous
From: Dustin Wenz
Date:
Subject: Re: Concurrent Users
Next
From: Rene Romero Benavides
Date:
Subject: 3 disks configured RAID 0 over 10 disks configured in RAID 5 (self replicating SAN)