Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal - Mailing list pgsql-admin

From Scott Ribe
Subject Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal
Date
Msg-id 42066935-6D27-46E3-8094-836D204816B7@elevated-dev.com
Whole thread Raw
In response to Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal  (Imre Oolberg <imre@auul.pri.ee>)
Responses Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
On Jan 3, 2011, at 11:22 AM, Imre Oolberg wrote:

> But http://www.postgresql.org/docs/9.0/interactive/continuous-archiving.html suggests to use tar on rsync and i guess
thatPostgreSQL recovery with wal files takes care of these inconsistencies that are created during copying filesystem,
right?

Yes, but the database is recovered to the consistent state as of the pg_start_backup command, as I pointed out to you
before.Results of transactions that commit after the pg_start_backup command will not be in the backed up database. 

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice





pgsql-admin by date:

Previous
From: Imre Oolberg
Date:
Subject: Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal
Next
From: Imre Oolberg
Date:
Subject: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal