Re: Can we change pg_rewind used without wal_log_hints and data_checksums
| От | lchch1990@sina.cn |
|---|---|
| Тема | Re: Can we change pg_rewind used without wal_log_hints and data_checksums |
| Дата | |
| Msg-id | 2026011515132967599611@sina.cn обсуждение исходный текст |
| Ответ на | Can we change pg_rewind used without wal_log_hints and data_checksums (lchch1990@sina.cn) |
| Список | pgsql-hackers |
On Thu, 2026-01-15 at 13:47 +0800, laurenz.albe@cybertec.at wrote: > Now if we run pg_rewind on server A, it examines the local WAL to find all the blocks > that were modified after the last common checkpoint (which happened in step 3 above). > If neither wal_log_hints = on nor checksums are enabled (which effectively forces > WAL-logging hint bit changes), there is no track of step 5 in the WAL, and pg_rewind > fails to copy that block from server B. The consequence is that after pg_rewind, the > row is *still* visible on server A because of the hint bits. That is data corruption. > Therefore, the requirement cannot be relaxed. Yes I known the step and I have check the mail link. As described in the top mail we can find some way to solve the problem so that pg_rewind can run without wal_log_hints and data_checksums. Currently pg_rewind search wal start at checkpoint lsn or redo lsn, I mean to search more wal to cover whole releated transactions so any releated pages with copyed, and we never warried about hint bits issue. Anyway, I wish this mail in order. ---- Best Regards, Movead Li
В списке pgsql-hackers по дате отправления: