Re: Data corruption issues using streaming replication on 9.0.14/9.2.5/9.3.1

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Data corruption issues using streaming replication on 9.0.14/9.2.5/9.3.1
Дата
Msg-id 20131120164622.GE18801@awork2.anarazel.de
обсуждение исходный текст
Ответ на Re: Data corruption issues using streaming replication on 9.0.14/9.2.5/9.3.1  (Heikki Linnakangas <hlinnakangas@vmware.com>)
Ответы Re: Data corruption issues using streaming replication on 9.0.14/9.2.5/9.3.1  (Andres Freund <andres@2ndquadrant.com>)
Список pgsql-hackers
On 2013-11-20 18:25:56 +0200, Heikki Linnakangas wrote:
> Isn't it possible that the standby has already incorrectly set
> HEAP_XMIN_INVALID hint bit on a page? The full page images generated by
> VACUUM FREEZE will correct the damage, but if not, e.g. because
> full_page_writes=off, strange things will happen.

The xlog_heap_freeze records should repair that afaics.

> Personally, I wouldn't trust anything less than a new base backup.

But I still tend to agree.

Greetings,

Andres Freund

-- Andres Freund                       http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training &
Services



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

Предыдущее
От: Sawada Masahiko
Дата:
Сообщение: Re: Logging WAL when updating hintbit
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: [PATCH] Add transforms feature