Re: Can we change pg_rewind used without wal_log_hints and data_checksums - Mailing list pgsql-hackers

From lchch1990@sina.cn
Subject Re: Can we change pg_rewind used without wal_log_hints and data_checksums
Date
Msg-id 2026011515132967599611@sina.cn
Whole thread Raw
In response to Can we change pg_rewind used without wal_log_hints and data_checksums  (lchch1990@sina.cn)
List 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 by date:

Previous
From: Andrey Silitskiy
Date:
Subject: Re: Exit walsender before confirming remote flush in logical replication
Next
From: Shinya Kato
Date:
Subject: Re: file_fdw: Support multi-line HEADER option.