Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Imre Oolberg <imre(at)auul(dot)pri(dot)ee>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal
Date: 2011-01-03 18:31:22
Message-ID: 42066935-6D27-46E3-8094-836D204816B7@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 that PostgreSQL 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(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Imre Oolberg 2011-01-03 18:37:04 Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal
Previous Message Imre Oolberg 2011-01-03 18:22:35 Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal