Improve pg_sync_replication_slots() to wait for primary to advance in more cases

Edit

ID

Title

Improve pg_sync_replication_slots() to wait for primary to advance in more cases

CI (CFBot)

Needs rebase! Needs rebase since 2 days. Failing since 2 days.
Additional links previous successfully applied patch (outdated):

Summary

Stats (from CFBot)

Unknown

Tags

Logical Replication

Created

2026-02-03 09:02:21

Last modified

2026-03-10 04:30:16 (15 hours ago)

Latest email

2026-03-05 09:29:50 (5 days ago)

Status

PG19-Final (2026-03-01 – 2026-03-31): Committed

Target version

Authors

Zhijie Hou (houzj)

Reviewers

Become reviewer

Committer

Amit Kapila (amitkapila)

Links

Emails

Improve pg_sync_replication_slots() to wait for primary to advance: First at 2025-06-24 10:40:58 by Ajin Cherian <itsajin at gmail.com>
Latest at 2026-03-05 09:29:50 by shveta malik <shveta.malik at gmail.com>
Latest attachment (v7-0002-Add-a-taptest.patch) at 2026-03-04 06:56:40 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com>
    Attachment (v7-0002-Add-a-taptest.patch) at 2026-03-04 06:56:40 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v6-0002-Add-a-taptest.patch) at 2026-02-13 02:24:50 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v5-0004-Add-a-taptest.patch) at 2026-02-11 08:44:33 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v4-0004-Add-a-taptest.patch) at 2026-02-10 07:55:19 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v3-0004-Add-a-taptest.patch) at 2026-02-09 06:06:34 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v2-0001-Improve-the-retry-logic-in-pg_sync_replication_sl.patch) at 2026-02-02 07:26:49 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v1-0002-Add-a-taptest.patch) at 2026-01-30 05:48:06 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v1-0001-Fix-an-intermittent-BF-failure.patch) at 2025-12-17 10:28:28 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v37-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-12-12 00:05:04 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v36_amit_1.patch.txt) at 2025-12-11 12:23:22 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v36-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-12-11 05:15:16 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v35-0001-Signal-backends-running-pg_sync_replication_slot.patch) at 2025-12-10 12:23:50 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v34-0001-Signal-backends-running-pg_sync_replication_slot.patch) at 2025-12-10 05:07:34 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v32-0001-Signal-backends-running-pg_sync_replication_slot.patch) at 2025-12-10 02:23:10 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v31-0001-Signal-backends-running-pg_sync_replication_slot.patch) at 2025-12-09 10:33:59 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v30-0001-Use-SIGUSR1-to-interrupt-slot-synchronization-wo.patch) at 2025-12-04 09:01:04 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v29-0001-Use-SIGUSR1-to-interrupt-slot-synchronization-wo.patch) at 2025-12-04 05:21:39 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v28-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-12-03 03:21:35 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v27-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-12-02 08:27:57 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v26-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-11-28 04:46:18 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v25-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-11-24 06:42:28 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v24-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-11-21 03:44:25 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v23-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-11-12 08:24:18 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v22-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-11-06 07:53:02 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v21-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-11-03 10:33:03 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v20-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-10-30 10:18:31 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v19-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-10-27 07:47:28 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v18-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-10-22 04:55:17 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v17-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-10-15 04:26:55 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-10-13 07:57:36 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (0001-Doc-update.patch.txt) at 2025-10-06 06:12:46 from shveta malik <shveta.malik at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-10-06 04:52:09 from shveta malik <shveta.malik at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-10-02 11:23:34 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-09-24 12:05:10 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (0001-comments-changes.patch.txt) at 2025-09-23 04:59:18 from shveta malik <shveta.malik at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-09-22 10:51:14 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-09-15 12:47:43 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-09-09 12:06:47 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-09-03 09:49:39 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Improve-initial-slot-synchronization-in-pg_sync_.patch) at 2025-09-03 06:28:02 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Improve-initial-slot-synchronization-in-pg_sync_r.patch) at 2025-08-26 04:28:30 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Improve-initial-slot-synchronization-in-pg_sync_r.patch) at 2025-08-20 05:22:58 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v7-0001-Improve-initial-slot-synchronization-in-pg_sync_r.patch) at 2025-08-19 05:24:57 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Improve-initial-slot-synchronization-in-pg_sync_r.patch) at 2025-08-14 01:58:26 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Improve-initial-slot-synchronization-in-pg_sync_r.patch) at 2025-08-11 08:05:43 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Improve-initial-slot-synchronization-in-pg_sync_r.patch) at 2025-08-06 02:03:28 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Improve-initial-slot-synchronization-in-pg_sync_r.patch) at 2025-07-31 09:40:57 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Improve-initial-slot-synchronization-in-pg_sync_r.patch) at 2025-07-16 10:16:51 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Improve-initial-slot-synchronization-in-pg_sync_r.patch) at 2025-07-16 09:30:17 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (0001-Improve-initial-slot-synchronization-in-pg_sync_repl.patch) at 2025-06-24 10:48:18 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (0001-Fix-stale-snapshot-issue.patch) at 2025-06-24 10:40:58 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)

History

When	Who	What
2026-03-10 04:30:16	Zhijie Hou (houzj)	Closed in commitfest PG19-Final with status: Committed
2026-03-10 04:30:16	Zhijie Hou (houzj)	Changed committer to amitkapila
2026-03-07 23:33:26	CFbot	Patch needs rebase
2026-02-03 09:02:49	Zhijie Hou (houzj)	Changed name to Improve pg_sync_replication_slots() to wait for primary to advance in more cases
2026-02-03 09:02:22	Zhijie Hou (houzj)	Attached mail thread CAFPTHDZAA+gWDntpa5ucqKKba41=tXmoXqN3q4rpjO9cdxgQrw@mail.gmail.com
2026-02-03 09:02:21	Zhijie Hou (houzj)	Created patch record

Edit