how reliable is pg_rewind?

Поиск
Список
Период
Сортировка
От Curt Kolovson
Тема how reliable is pg_rewind?
Дата
Msg-id CANhYJV4xd7kApkMm18pTg9CN8CEUjrZeW4boNJ2aQ8xWicS74A@mail.gmail.com
обсуждение исходный текст
Ответы Re: how reliable is pg_rewind?  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-general
When trying to resync an old primary to become a new standby, I have found that pg_rewind only works occasionally. How reliable/robust is pg_rewind, and what are its limitations? We have observed that approx half our FPIs in the WALs are due to XLOG/FPI_FOR_HINT. The only reason we've set wal_log_hints=on is so that we can  use pg_rewind. But if pg_rewind is unreliable, we would rather turn off wal_log_hints. Any info on the reliability of pg_rewind and its limitations would be appreciated.

Thanks, Curt 

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

Предыдущее
От: Michael Lewis
Дата:
Сообщение: Re: Apparent missed query optimization with self-join and inner grouping
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Apparent missed query optimization with self-join and inner grouping