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

Поиск
Список
Период
Сортировка
От Scott Ribe
Тема Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal
Дата
Msg-id 42066935-6D27-46E3-8094-836D204816B7@elevated-dev.com
обсуждение исходный текст
Ответ на Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal  (Imre Oolberg <imre@auul.pri.ee>)
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: Imre Oolberg
Дата:
Сообщение: Re: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal
Следующее
От: Imre Oolberg
Дата:
Сообщение: Re: pg v. 8.4.5 misses objects and data after restoring from backup using wal