Make async slave to wait for lsn to be replayed

Edit
ID 4221
Title Make async slave to wait for lsn to be replayed
Topic Replication & Recovery
Created 2023-02-28 10:23:08
Last modified 2024-08-02 18:25:44 (3 months, 2 weeks ago)
Latest email 2024-09-17 09:00:00 (2 months ago)
Status
2024-09: Committed
2024-07: Moved to next CF
2024-03: Moved to next CF
2024-01: Moved to next CF
2023-11: Moved to next CF
2023-09: Moved to next CF
2023-07: Moved to next CF
2023-03: Moved to next CF
Target version 18
Authors Ivan Kartyshov (fenimorkin)
Reviewers Bharath Rupireddy (bharathrupireddy)Become reviewer
Committer Alexander Korotkov (smagen)
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/4221
git checkout commitfest/cf/4221
Emails
Re: [HACKERS] make async slave to wait for lsn to be replayed
First at 2023-02-28 10:10:47 by Kartyshov Ivan <i.kartyshov at postgrespro.ru>
Latest at 2024-09-17 09:00:00 by Alexander Lakhin <exclusion at gmail.com>
Latest attachment (v2-0001-Minor-cleanup-related-to-pg_wal_replay_wait-proce.patch) at 2024-09-17 07:47:02 from Alexander Korotkov <aekorotkov at gmail.com>
    Attachment (v2-0001-Minor-cleanup-related-to-pg_wal_replay_wait-proce.patch) at 2024-09-17 07:47:02 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v1-0002-Add-missing-wait_for_catchup-call-in-043_wal_repl.patch) at 2024-09-16 18:55:50 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v3-0002-Improve-header-comment-for-WaitLSNSetLatches.patch) at 2024-08-10 17:18:53 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v2-0002-Improve-header-comment-for-WaitLSNSetLatches.patch) at 2024-08-10 16:33:57 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v1-0002-Improve-header-comment-for-WaitLSNSetLatches.patch) at 2024-08-06 02:17:10 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v23-0001-Implement-pg_wal_replay_wait-stored-procedure.patch) at 2024-07-31 16:40:48 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v22-0001-Implement-pg_wal_replay_wait-stored-procedure.patch) at 2024-07-15 11:02:03 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v21-0001-Implement-pg_wal_replay_wait-stored-procedure.patch) at 2024-07-15 01:24:19 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v20-Implement-pg_wal_replay_wait-store.patch) at 2024-07-09 09:51:23 from Kartyshov Ivan <i.kartyshov at postgrespro.ru> (Patch: Yes)
    Attachment (v19-0001-Implement-pg_wal_replay_wait-stored-procedure.patch) at 2024-06-14 12:46:15 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v18-0001-Implement-pg_wal_replay_wait-stored-procedure.patch) at 2024-06-12 08:36:05 from Kartyshov Ivan <i.kartyshov at postgrespro.ru> (Patch: Yes)
    Attachment (additional_test.patch) at 2024-04-10 15:12:00 from Kartyshov Ivan <i.kartyshov at postgrespro.ru> (Patch: Yes)
    Attachment (v2-0001-Use-an-LWLock-instead-of-a-spinlock-in-waitlsn.c.patch) at 2024-04-03 21:35:37 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (0001-Use-an-LWLock-instead-of-a-spinlock-in-waitlsn.c.patch) at 2024-04-03 16:55:35 from Alvaro Herrera <alvherre at alvh.no-ip.org> (Patch: Yes)
    Attachment (v17-0001-Implement-pg_wal_replay_wait-stored-procedure.patch) at 2024-04-01 10:27:09 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Implement-pg_wal_replay_wait-stored-procedure.patch) at 2024-03-31 02:11:27 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Implement-pg_wal_replay_wait-stored-procedure.patch) at 2024-03-30 14:14:28 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Implement-pg_wal_replay_wait-stored-procedure.patch) at 2024-03-29 12:44:56 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Implement-pg_wait_for_wal_replay_lsn-stored-proc.patch) at 2024-03-28 12:39:25 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Implement-pg_wait_for_wal_replay_lsn-stored-proc.patch) at 2024-03-28 06:23:28 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v14_0002-Procedure-wait-lsn.patch) at 2024-03-26 14:06:51 from Kartyshov Ivan <i.kartyshov at postgrespro.ru> (Patch: Yes)
    Attachment (v14_0001-Procedure-wait-lsn.patch) at 2024-03-22 19:42:52 from Kartyshov Ivan <i.kartyshov at postgrespro.ru> (Patch: Yes)
    Attachment (v13_0001-Procedure-wait-lsn.patch) at 2024-03-19 22:34:51 from Kartyshov Ivan <i.kartyshov at postgrespro.ru> (Patch: Yes)
    Attachment (v12_0001-Procedure-wait-lsn.patch) at 2024-03-19 17:38:55 from Kartyshov Ivan <i.kartyshov at postgrespro.ru> (Patch: Yes)
    Attachment (v11-0001-Implement-AFTER-clause-for-BEGIN-command.patch) at 2024-03-18 09:54:11 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Implement-AFTER-clause-for-BEGIN-command.patch) at 2024-03-15 20:32:23 from Kartyshov Ivan <i.kartyshov at postgrespro.ru> (Patch: Yes)
    Attachment (v10_after_within.patch) at 2024-03-15 19:59:44 from Kartyshov Ivan <i.kartyshov at postgrespro.ru> (Patch: Yes)
    Attachment (v10-0001-Implement-AFTER-clause-for-BEGIN-command.patch) at 2024-03-15 19:47:55 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Implement-AFTER-clause-for-BEGIN-command.patch) at 2024-03-15 14:20:25 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Implement-AFTER-clause-for-BEGIN-command.patch) at 2024-03-11 10:44:53 from Alexander Korotkov <aekorotkov at gmail.com> (Patch: Yes)
    Attachment (wait_classic_v7.patch) at 2024-03-07 11:44:32 from Kartyshov Ivan <i.kartyshov at postgrespro.ru> (Patch: Yes)
    Attachment (wait_after_within_v5.patch) at 2024-02-01 21:29:28 from Kartyshov Ivan <i.kartyshov at postgrespro.ru> (Patch: Yes)
    Attachment (wait_after_within_v4.patch) at 2024-01-17 08:16:35 from Kartyshov Ivan <i.kartyshov at postgrespro.ru> (Patch: Yes)
    Attachment (wait_classic_v4.patch) at 2024-01-11 08:57:44 from Kartyshov Ivan <i.kartyshov at postgrespro.ru> (Patch: Yes)
    Attachment (wait_after_within_v2.patch) at 2023-12-08 09:46:55 from Kartyshov Ivan <i.kartyshov at postgrespro.ru> (Patch: Yes)
    Attachment (wait_proc_v6.patch) at 2023-11-20 11:10:43 from Картышов Иван <i.kartyshov at postgrespro.ru> (Patch: Yes)
    Attachment (wait_proc_v5.patch) at 2023-06-30 08:32:23 from Картышов Иван <i.kartyshov at postgrespro.ru> (Patch: Yes)
    Attachment (wait_proc_v4.patch) at 2023-03-07 06:55:48 from Kartyshov Ivan <i.kartyshov at postgrespro.ru> (Patch: Yes)
    Attachment (wait_proc_v3.patch) at 2023-03-06 09:40:16 from Kartyshov Ivan <i.kartyshov at postgrespro.ru> (Patch: Yes)
    Attachment (wait_proc_v2.patch) at 2023-03-04 15:36:49 from Kartyshov Ivan <i.kartyshov at postgrespro.ru> (Patch: Yes)
    Attachment (wait_after_within_v1.patch) at 2023-02-28 10:10:47 from Kartyshov Ivan <i.kartyshov at postgrespro.ru> (Patch: Yes)
History
When Who What
2024-08-02 18:25:44 Alexander Korotkov (smagen) Changed targetversion to 18
2024-08-02 18:25:37 Alexander Korotkov (smagen) Closed in commitfest 2024-09 with status: Committed
2024-08-01 06:23:32 Corey Huinker (coreyh) Closed in commitfest 2024-07 with status: Moved to next CF
2024-06-12 10:14:36 Ivan Kartyshov (fenimorkin) New status: Needs review
2024-04-16 15:51:47 Ivan Kartyshov (fenimorkin) Closed in commitfest 2024-03 with status: Moved to next CF
2024-04-16 15:51:26 Ivan Kartyshov (fenimorkin) New status: Waiting on Author
2024-04-02 19:59:01 Alexander Korotkov (smagen) Closed in commitfest 2024-03 with status: Committed
2024-04-02 19:58:55 Alexander Korotkov (smagen) Changed committer to smagen
2024-04-02 19:58:55 Alexander Korotkov (smagen) Changed targetversion to 17
2024-03-17 05:55:15 Bharath Rupireddy (bharathrupireddy) Added bharathrupireddy as reviewer
2024-03-07 11:53:11 Ivan Kartyshov (fenimorkin) Attached mail thread eb12f9b03851bb2583adab5df9579b4b@postgrespro.ru
2024-03-07 11:52:32 Ivan Kartyshov (fenimorkin) Detached mail thread eb12f9b03851bb2583adab5df9579b4b@postgrespro.ru
2024-02-05 10:31:28 Ivan Kartyshov (fenimorkin) New status: Needs review
2024-02-01 16:20:05 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-01 with status: Moved to next CF
2024-01-26 15:04:40 vigneshwaran C (vignesh.postgres) New status: Waiting on Author
2023-12-04 09:58:44 John Naylor (john.naylor) Closed in commitfest 2023-11 with status: Moved to next CF
2023-11-21 10:22:29 Ivan Kartyshov (fenimorkin) Attached mail thread eb12f9b03851bb2583adab5df9579b4b@postgrespro.ru
2023-11-21 10:22:07 Ivan Kartyshov (fenimorkin) Detached mail thread eb12f9b03851bb2583adab5df9579b4b@postgrespro.ru
2023-11-20 11:30:13 Ivan Kartyshov (fenimorkin) Attached mail thread eb12f9b03851bb2583adab5df9579b4b@postgrespro.ru
2023-11-20 11:29:19 Ivan Kartyshov (fenimorkin) Detached mail thread eb12f9b03851bb2583adab5df9579b4b@postgrespro.ru
2023-11-20 11:20:53 Ivan Kartyshov (fenimorkin) Attached mail thread eb12f9b03851bb2583adab5df9579b4b@postgrespro.ru
2023-11-20 11:20:40 Ivan Kartyshov (fenimorkin) Detached mail thread eb12f9b03851bb2583adab5df9579b4b@postgrespro.ru
2023-10-02 09:56:53 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Moved to next CF
2023-09-04 07:20:16 Peter Eisentraut (petere) Changed reviewers to
2023-08-03 08:12:50 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2023-07 with status: Moved to next CF
2023-04-09 03:08:50 Greg Stark (stark) Changed reviewers to Greg Stark (stark)
2023-04-09 03:08:06 Greg Stark (stark) Closed in commitfest 2023-03 with status: Moved to next CF
2023-04-09 03:05:03 Greg Stark (stark) Changed reviewers to
2023-04-09 03:05:03 Greg Stark (stark) Changed targetversion to None
2023-03-07 07:39:22 Ivan Kartyshov (fenimorkin) New status: Needs review
2023-03-01 20:31:24 Greg Stark (stark) Added stark as reviewer
2023-03-01 20:31:09 Greg Stark (stark) New status: Waiting on Author
2023-02-28 10:24:35 Ivan Kartyshov (fenimorkin) Changed authors to Ivan Kartyshov (fenimorkin)
2023-02-28 10:24:35 Ivan Kartyshov (fenimorkin) Changed targetversion to 16
2023-02-28 10:23:08 Ivan Kartyshov (fenimorkin) Attached mail thread eb12f9b03851bb2583adab5df9579b4b@postgrespro.ru
2023-02-28 10:23:08 Ivan Kartyshov (fenimorkin) Created patch record
Edit