Re: Snapshot backups

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Snapshot backups
Дата
Msg-id CAMkU=1xG2zL2w-rjKceP8yM24A_jNtW-9LobHPKS-mrpdxfBDQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Snapshot backups  (James Sewell <james.sewell@lisasoft.com>)
Ответы Re: Snapshot backups  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Tuesday, July 30, 2013, James Sewell wrote:
I understand what you are saying, and I understand how the backup_label works - but I still don't understand why the pg_start and pg_stop commands are REQUIRED when doing a snapshot backup to ensure data integrity. 

Surely not using them and restoring a snapshot is the same as starting after a crash, and will result in log replay to get to the latest possible consistent state?

That's true provided that all of your data is on a single volume, and you trust your "snapshot" to be free of bugs.

Cheers,

Jeff

В списке pgsql-general по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: more fun with building 9.3beta2
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Snapshot backups