From: Scott Ribe <scott_ribe@elevated-dev.com>
To: Imre Oolberg <imre@auul.pri.ee>
Cc: pgsql-admin@postgresql.org
Subject: Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal
Date: Mon, 3 Jan 2011 11:31:22 -0700
Message-ID: <42066935-6D27-46E3-8094-836D204816B7@elevated-dev.com> (raw)
In-Reply-To: <4D2213EB.7090700@auul.pri.ee>
References: <AANLkTikY_XJ0Ok7bLGVxXXfGgenfnzJ4RnSiM_H40FCM@mail.gmail.com>
<4D2213EB.7090700@auul.pri.ee>
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@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, imre@auul.pri.ee
Subject: Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal
In-Reply-To: <42066935-6D27-46E3-8094-836D204816B7@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox