Re: Will Altering and Modifying tables during backup result in acorrupted server after the restore?

Поиск
Список
Период
Сортировка
От Christoph Moench-Tegeder
Тема Re: Will Altering and Modifying tables during backup result in acorrupted server after the restore?
Дата
Msg-id 20180521164919.GA97744@elch.exwg.net
обсуждение исходный текст
Ответ на Will Altering and Modifying tables during backup result in acorrupted server after the restore?  (Yashwanth Govinda Setty <ygovindasetty@commvault.com>)
Ответы Re: Will Altering and Modifying tables during backup result in acorrupted server after the restore?  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-general
## Yashwanth Govinda Setty (ygovindasetty@commvault.com):

>   2.  Restore the server with transaction logs

This is missing a lot of details. If you do it right - see your email
thread from one week ago - you will be able to recover the database
server to a state as of the _end_ of the backup process (as marked by
the return of the pg_stop_backup() command).
If you do not follow the backup/restore documentation to the letter,
the database will be corrupted and will not start (sometimes people
report with haphazard backup schemes, but that's just more luck than
they deserve, and nobody should rely on that).

Regards,
Christoph

-- 
Spare Space


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

Предыдущее
От: Alexey Dokuchaev
Дата:
Сообщение: Re: Aggregate functions with FROM clause and ROW_COUNT diagnostics
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Aggregate functions with FROM clause and ROW_COUNT diagnostics