Minimal logical decoding on standbys

Edit
Title Minimal logical decoding on standbys
Topic Replication & Recovery
Created 2022-06-30 14:45:01
Last modified 2023-04-08 16:31:01 (5 months, 2 weeks ago)
Latest email 2023-04-08 17:12:16 (5 months, 2 weeks ago)
Status
2023-03: Committed
2023-01: Moved to next CF
2022-11: Moved to next CF
2022-09: Moved to next CF
2022-07: Moved to next CF
Target version 16
Authors Bertrand Drouvot (bdrouvot)
Reviewers Bharath Rupireddy (bharathrupireddy)Become reviewer
Committer Andres Freund (andresfreund)
Links
Emails
Minimal logical decoding on standbys
First at 2018-12-12 20:41:54 by Andres Freund <andres at anarazel.de>
Latest at 2023-04-08 17:12:16 by "Jonathan S. Katz" <jkatz at postgresql.org>
Latest attachment (sub_in_progress.patch) at 2023-04-07 20:58:19 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com>
    Attachment (sub_in_progress.patch) at 2023-04-07 20:58:19 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (va67-0001-Replace-a-replication-slot-s-invalidated_at-LSN.patch) at 2023-04-07 18:12:26 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (v65-66-InvalidateObsoleteReplicationSlots_API.patch) at 2023-04-07 15:13:13 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (va65-0001-replication-slots-replace-invalidated_at-LSN-wi.patch) at 2023-04-07 07:50:09 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (v62-63-0005-New-TAP-test-for-logical-decoding-on-standby.patch) at 2023-04-07 06:09:50 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v63-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-04-07 05:02:04 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v62-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-04-06 13:00:57 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v61-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-04-05 15:56:14 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v60-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-04-05 07:59:24 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v59-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-04-04 14:53:31 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v58-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-04-04 09:42:45 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v57-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-04-03 18:17:19 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v56-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-04-03 15:20:55 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v55-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-04-02 08:27:45 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v54-0007-Doc-changes-describing-details-about-logical-dec.patch) at 2023-03-31 10:45:51 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Introduce-ConditionVariableEventSleep.patch) at 2023-03-31 09:44:33 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (v53-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-03-30 16:23:41 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (0004_new_API.txt) at 2023-03-10 11:33:50 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (0004_new_API.txt) at 2023-03-08 10:25:10 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v52-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-03-04 11:19:57 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Introduce-ConditionVariableEventSleep.patch) at 2023-03-03 07:58:07 from Jeff Davis <pgsql at j-davis.com> (Patch: Yes)
    Attachment (0004-CV-POC.txt) at 2023-03-02 09:20:09 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v51-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-02-27 08:40:58 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v50-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-02-13 15:27:20 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v49-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-02-07 15:29:07 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v48-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-02-07 10:36:48 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v47-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-02-06 11:36:56 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v46-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-01-31 11:50:50 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v45-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-01-30 16:18:39 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v44-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-01-27 12:09:16 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v43-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-01-26 17:56:10 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v42-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-01-23 11:03:35 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v41-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-01-19 08:13:22 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v40-0006-Doc-changes-describing-details-about-logical-dec.patch) at 2023-01-16 14:28:54 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v39-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2023-01-12 11:57:39 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v38-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2023-01-11 18:04:48 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v37-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2023-01-10 08:33:21 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v36-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2023-01-03 07:41:22 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v35-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2022-12-22 07:50:34 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v1-0001-fix-some-comments.patch) at 2022-12-21 09:06:42 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (kpt_gist_setup.sql) at 2022-12-20 21:41:54 from Robert Haas <robertmhaas at gmail.com> (Patch: No)
    Attachment (kpt_hash_setup.sql) at 2022-12-20 20:39:26 from Robert Haas <robertmhaas at gmail.com> (Patch: No)
    Attachment (v34-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2022-12-20 20:35:13 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v33-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2022-12-20 09:51:59 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v32-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2022-12-16 10:33:50 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v31-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2022-12-14 13:05:15 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v30-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2022-12-10 08:09:27 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v29-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2022-12-08 11:07:22 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v28-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2022-12-07 09:00:25 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v27-0006-Fixing-Walsender-corner-case-with-logical-decodi.patch) at 2022-12-02 09:32:23 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v27-0001-Add-info-in-WAL-records-in-preparation-for-logic.patch) at 2022-11-25 10:26:16 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v26-0001-Add-info-in-WAL-records-in-preparation-for-logic.patch) at 2022-09-30 12:11:39 from "Drouvot, Bertrand" <bertranddrouvot.pg at gmail.com> (Patch: Yes)
    Attachment (v25-0001-Add-info-in-WAL-records-in-preparation-for-logic.patch) at 2021-10-27 06:55:45 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v24-0001-Add-info-in-WAL-records-in-preparation-for-logic.patch) at 2021-09-15 11:36:00 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v23-0006-Logical-Decoding-On-Standby-WalSender-Corner-Case.patch) at 2021-09-08 10:08:43 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v23-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-08-06 11:27:46 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v22-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-08-02 14:45:23 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v21-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-07-27 07:23:48 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v20-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-07-16 08:07:10 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v19-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-06-22 10:38:34 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v18-0001-Add-info-in-WAL-records-in-preparation-for-logic.patch) at 2021-06-14 05:41:12 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v17-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-04-08 10:19:00 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v16-0001-Allow-logical-decoding-on-standby.patch) at 2021-04-07 09:06:11 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v15-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-04-06 12:30:29 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v14-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-03-24 06:56:51 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v13-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-03-23 17:31:48 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v12-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-03-23 11:47:29 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v11-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-03-22 15:56:36 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v10-0005-Doc-changes-describing-details-about-logical-dec.patch) at 2021-03-18 08:33:45 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v9-0001-Allow-logical-decoding-on-standby.patch) at 2021-02-04 16:49:23 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v8-0005-Doc-changes-describing-details-about-logical-deco.patch) at 2021-01-26 09:31:33 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v8-0001-Allow-logical-decoding-on-standby.patch) at 2021-01-18 11:48:31 from "Drouvot, Bertrand" <bdrouvot at amazon.com> (Patch: Yes)
    Attachment (v7-0001-Allow-logical-decoding-on-standby.patch) at 2020-12-15 18:24:38 from Fabrízio de Royes Mello <fabriziomello at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Allow-logical-decoding-on-standby.patch) at 2020-03-18 18:29:46 from Alvaro Herrera <alvherre at 2ndquadrant.com> (Patch: Yes)
    Attachment (logicaldecodng_standby_v5_rebased.tar.gz) at 2020-01-16 04:42:24 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logicaldecodng_standby_v5.tar.gz) at 2019-12-26 11:05:25 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logicaldecodng_standby_v4_rebased.tar.gz) at 2019-11-04 11:06:21 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logicaldecodng_standby_v4.tar.gz) at 2019-10-03 06:35:15 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logicaldecodng_standby_v3.tar.gz) at 2019-09-30 11:34:57 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logicaldecodng_standby_v2.tar.gz) at 2019-09-26 09:14:11 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logicaldecodng_standby_v1_rebased.tar.gz) at 2019-09-13 11:19:54 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logicaldecodng_standby.tar.gz) at 2019-07-19 05:45:49 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logical-decoding-on-standby_v12.patch) at 2019-07-10 11:42:35 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logical-decoding-on-standby_v11.patch) at 2019-07-01 05:34:05 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logical-decoding-on-standby_v10.patch) at 2019-06-25 10:29:28 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logical-decoding-on-standby_v9.patch) at 2019-06-24 18:28:50 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logical-decoding-on-standby_v8.patch) at 2019-06-20 09:58:10 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: No)
    Attachment (logical-decoding-on-standby_v7.patch) at 2019-06-14 11:24:19 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: Yes)
    Attachment (logical-decoding-on-standby_v6.patch) at 2019-06-12 12:00:02 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: Yes)
    Attachment (logical-decoding-on-standby_v5.patch) at 2019-05-27 11:34:44 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: Yes)
    Attachment (handle_wal_level_changes_WIP.patch) at 2019-05-24 15:30:36 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: Yes)
    Attachment (logical-decoding-on-standby_v4_rebased.patch) at 2019-05-22 09:32:10 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: Yes)
    Attachment (logical-decoding-on-standby_v4.patch) at 2019-04-09 16:53:16 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: Yes)
    Attachment (logical-decoding-on-standby_v3.patch) at 2019-04-05 11:38:39 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: Yes)
    Attachment (logical-decoding-on-standby_v2.patch) at 2019-04-03 14:27:33 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: Yes)
    Attachment (0001-Logical-decoding-on-standby_rebased.patch) at 2019-03-04 08:39:52 from Amit Khandekar <amitdkhan.pg at gmail.com> (Patch: Yes)
    Attachment (index-page-vacuum-xid-horizon-primary.diff) at 2018-12-14 00:55:21 from Andres Freund <andres at anarazel.de> (Patch: Yes)
    Attachment (logical-decoding-on-standby.diff) at 2018-12-12 20:41:54 from Andres Freund <andres at anarazel.de> (Patch: Yes)
History
When Who What
2023-04-08 16:31:01 Andres Freund (andresfreund) Closed in commitfest 2023-03 with status: Committed
2023-04-08 16:31:01 Andres Freund (andresfreund) Changed committer to andresfreund
2023-01-31 16:20:39 vigneshwaran C (vignesh.postgres) Closed in commitfest 2023-01 with status: Moved to next CF
2023-01-11 06:37:17 Bharath Rupireddy (bharathrupireddy) Added bharathrupireddy as reviewer
2022-12-02 05:19:30 Michael Paquier (michael-kun) Closed in commitfest 2022-11 with status: Moved to next CF
2022-10-07 05:44:29 Michael Paquier (michael-kun) Closed in commitfest 2022-09 with status: Moved to next CF
2022-10-07 05:44:25 Michael Paquier (michael-kun) New status: Needs review
2022-08-02 18:34:30 Jacob Champion (jchampion) Closed in commitfest 2022-07 with status: Moved to next CF
2022-06-30 14:46:00 Bertrand Drouvot (bdrouvot) New status: Waiting on Author
2022-06-30 14:45:18 Bertrand Drouvot (bdrouvot) Changed authors to Bertrand Drouvot (bdrouvot)
2022-06-30 14:45:18 Bertrand Drouvot (bdrouvot) Changed targetversion to 16
2022-06-30 14:45:02 Bertrand Drouvot (bdrouvot) Attached mail thread 20181212204154.nsxf3gzqv3gesl32@alap3.anarazel.de
2022-06-30 14:45:01 Bertrand Drouvot (bdrouvot) Created patch record
Edit