| From: | Jeff Davis <jdavis(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Recovery: ensure CLOG updates wait for minRecoveryPoint. |
| Date: | 2026-11-18 22:36:57 |
| Message-ID: | E1xToGu-00000000Itf-3VHq@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Recovery: ensure CLOG updates wait for minRecoveryPoint.
The hot_standby=on case already used TransactionIdAsyncCommitTree();
use that for hot_standby=off, too.
Before this commit, it was possible that the CLOG status could reach
disk without advancing minRecoveryPoint. Recovering with PITR prior to
the transaction's commit record could incorrectly see the transaction
as committed.
Reviewed-by: Ayush Tiwari <ayushtiwari(dot)slg01(at)gmail(dot)com>
Discussion: https://postgr.es/m/62b070d14df4d9d5f44cb8da6f15546c30259053.camel@j-davis.com
Backpatch-through: 15
Branch
------
REL_18_STABLE
Details
-------
https://git.postgresql.org/pg/commitdiff/cce784243d5478bdbdb535e0a1d3d06ddc136021
Modified Files
--------------
src/backend/access/transam/clog.c | 5 -----
src/backend/access/transam/xact.c | 17 ++++++++---------
2 files changed, 8 insertions(+), 14 deletions(-)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2026-11-18 22:37:02 | pgsql: Recovery: ensure CLOG updates wait for minRecoveryPoint. |
| Previous Message | Jeff Davis | 2026-11-18 22:36:53 | pgsql: Recovery: ensure CLOG updates wait for minRecoveryPoint. |