pgsql: Recovery: ensure CLOG updates wait for minRecoveryPoint.

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:53
Message-ID: E1xToGq-00000000It1-0Bx4@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_19_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/a18df827b6c603973632bd630f5e6ce3adaab9ce

Modified Files
--------------
src/backend/access/transam/clog.c | 5 -----
src/backend/access/transam/xact.c | 17 ++++++++---------
2 files changed, 8 insertions(+), 14 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Jeff Davis 2026-11-18 22:36:57 pgsql: Recovery: ensure CLOG updates wait for minRecoveryPoint.
Previous Message Jeff Davis 2026-11-18 22:36:46 pgsql: Recovery: ensure CLOG updates wait for minRecoveryPoint.