allow to upgrade publisher node

Edit
Title allow to upgrade publisher node
Topic Replication & Recovery
Created 2023-04-12 07:50:52
Last modified 2023-11-22 08:46:57 (4 months, 4 weeks ago)
Latest email 2023-12-04 06:29:27 (4 months, 2 weeks ago)
Status
2023-11: Committed
2023-09: Moved to next CF
2023-07: Moved to next CF
Target version 17
Authors Hayato Kuroda (ha-kun)
Reviewers Bharath Rupireddy (bharathrupireddy), Peter Smith (smithpb2250)Become reviewer
Committer Amit Kapila (amitkapila)
Links
Emails
[PoC] pg_upgrade: allow to upgrade publisher node
First at 2023-04-04 07:00:01 by "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com>
Latest at 2023-12-04 06:29:27 by "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com>
Latest attachment (add_wait.patch) at 2023-12-04 06:29:27 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com>
    Attachment (add_wait.patch) at 2023-12-04 06:29:27 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (disable_autovacuum.patch) at 2023-11-29 09:26:26 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (Upgrade_verbose_issue_fix_v2.patch) at 2023-11-08 17:35:24 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (Upgrade_verbose_issue_fix.patch) at 2023-11-08 03:13:50 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (change_dir.patch) at 2023-11-07 04:14:25 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (fix_meson.patch) at 2023-10-27 07:44:15 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (0001-Shorten-some-files.patch) at 2023-10-27 04:40:43 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v59-0001-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-10-25 08:05:08 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v58-0001-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-10-25 06:09:07 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v57-0001-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-10-24 06:02:21 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v56-0001-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-10-23 05:39:59 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v55-0001-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-10-20 15:20:51 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (test_issue.patch) at 2023-10-20 03:24:23 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v54-0001-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-10-19 12:53:51 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v53-0001-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-10-19 10:42:50 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v52-0001-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-10-18 09:25:38 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v51-0001-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-10-17 12:15:04 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v50_changes_amit_1.patch.txt) at 2023-10-16 09:13:57 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v50-0001-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-10-14 05:15:27 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v49-0001-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-10-12 11:41:01 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v48-0001-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-10-11 10:57:45 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v47_changes_amit_1.patch.txt) at 2023-10-11 07:43:08 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v47-0001-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-10-10 11:21:23 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v46-0001-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-10-06 13:00:13 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v2_kuroda_mod.txt) at 2023-10-04 01:00:34 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (kuroda_mod.txt) at 2023-10-03 09:40:26 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v45-0001-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-10-03 04:28:44 from Bharath Rupireddy <bharath.rupireddyforpostgres at gmail.com> (Patch: Yes)
    Attachment (v45-0001-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-09-26 05:21:48 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v44-0001-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-09-23 04:48:19 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v43-0001-pg_upgrade-Allow-to-replicate-logical-replicati.patch) at 2023-09-21 10:44:12 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v42-0001-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-09-20 11:28:33 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v41-0001-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-09-20 05:30:11 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v40-0001-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-09-19 12:27:31 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v39-0001-pg_upgrade-Allow-to-replicate-logical-replicati.patch) at 2023-09-19 06:17:45 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (changes_amit_1.txt) at 2023-09-18 11:49:05 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (perf_script.zip) at 2023-09-18 11:16:41 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: No)
    Attachment (v38-0001-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-09-15 13:02:02 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v38-0003-Another-one-Reads-all-WAL-records-ahead-confirme.txt) at 2023-09-15 12:32:55 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v37-0001-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-09-15 03:13:48 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v36-0001-Flush-logical-slots-to-disk-during-a-shutdown-ch.patch) at 2023-09-12 11:50:22 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v35-0001-Persist-logical-slots-to-disk-during-a-shutdown-.patch) at 2023-09-11 13:21:39 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (cosmetic_improvements_amit.1.patch) at 2023-09-11 06:53:05 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v34-0001-Persist-logical-slots-to-disk-during-a-shutdown-.patch) at 2023-09-08 13:01:10 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v33-0001-Persist-logical-slots-to-disk-during-a-shutdown-.patch) at 2023-09-07 12:24:23 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v32-0001-Persist-logical-slots-to-disk-during-a-shutdown-.patch) at 2023-09-06 13:35:02 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (0001-use-simple-ptr-list_topup_patch) at 2023-09-06 03:17:52 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v31-0001-Persist-logical-slots-to-disk-during-a-shutdown-.patch) at 2023-09-05 07:34:48 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v30-0002-pg_upgrade-Allow-to-replicate-logical-replicatio.patch) at 2023-09-01 13:04:49 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v29-0001-Persist-logical-slots-to-disk-during-a-shutdown-.patch) at 2023-09-01 04:46:18 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (changes_amit.1.patch) at 2023-08-31 10:34:41 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v28-0001-Persist-logical-slots-to-disk-during-a-shutdown-.patch) at 2023-08-29 11:58:31 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v27-0001-Persist-to-disk-logical-slots-during-a-shutdown-.patch) at 2023-08-28 13:01:47 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v26-0001-Persist-to-disk-logical-slots-during-a-shutdown-.patch) at 2023-08-26 04:23:46 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v25-0001-Persist-to-disk-logical-slots-during-a-shutdown-.patch) at 2023-08-25 02:10:12 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v24-0001-Always-persist-to-disk-logical-slots-during-a-sh.patch) at 2023-08-23 02:59:00 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v23-0001-Always-persist-to-disk-logical-slots-during-a-sh.patch) at 2023-08-21 13:02:30 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (mod_amit_1.patch) at 2023-08-19 10:09:20 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v22-0001-Always-persist-to-disk-logical-slots-during-a-sh.patch) at 2023-08-18 13:51:36 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (perf_test_graph.png) at 2023-08-17 10:18:42 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: No)
    Attachment (v21-0001-Always-persist-to-disk-logical-slots-during-a-sh.patch) at 2023-08-16 10:25:03 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v20-0003-pg_upgrade-Add-check-function-for-logical-replic.patch) at 2023-08-15 04:13:49 from "Zhijie Hou (Fujitsu)" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v19-0001-Always-persist-to-disk-logical-slots-during-a-sh.patch) at 2023-08-10 15:02:43 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (test_01.sh) at 2023-08-07 10:53:19 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: No)
    Attachment (test_0803.sh) at 2023-08-03 09:28:33 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: No)
    Attachment (v18-0001-pg_upgrade-Add-include-logical-replication-slots.patch) at 2023-08-02 08:13:38 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (0004-pg_upgrade-Add-check-function-for-include-logical-re.patch) at 2023-07-28 11:59:06 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (0001-Send-shutdown-checkpoint-record-to-subscriber.patch) at 2023-07-21 07:30:14 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v17-0001-pg_upgrade-Add-include-logical-replication-slots.patch) at 2023-07-19 14:02:16 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v16-0001-pg_upgrade-Add-include-logical-replication-slots.patch) at 2023-06-08 03:54:46 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v15-0001-pg_upgrade-Add-include-logical-replication-slots.patch) at 2023-05-22 10:20:31 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v14-0001-pg_upgrade-Add-include-logical-replication-slots.patch) at 2023-05-16 06:15:00 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v13-0001-pg_upgrade-Add-include-logical-replication-slots.patch) at 2023-05-15 06:29:49 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v12-0001-pg_upgrade-Add-include-logical-replication-slots.patch) at 2023-05-11 08:55:08 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v11-0001-pg_upgrade-Add-include-logical-replication-slots.patch) at 2023-05-09 09:43:35 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v10-0001-pg_upgrade-Add-include-logical-replication-slots.patch) at 2023-04-26 12:00:08 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v9-0001-pg_upgrade-Add-include-logical-replication-slots-.patch) at 2023-04-24 12:03:05 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v8-0001-pg_upgrade-Add-include-logical-replication-slots-.patch) at 2023-04-20 05:31:16 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v7-0001-pg_upgrade-Add-include-logical-replication-slots-.patch) at 2023-04-14 10:30:27 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v1-0001-Always-persist-to-disk-logical-slots-during-a-shu.patch.txt) at 2023-04-14 06:12:48 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v6-0001-pg_upgrade-Add-include-logical-replication-slots-.patch) at 2023-04-14 05:53:37 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v5-0001-pg_upgrade-Add-include-logical-replication-slots-.patch) at 2023-04-12 07:55:28 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v4-0001-pg_upgrade-Add-include-logical-replication-slots-.patch) at 2023-04-11 10:27:08 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (test.sh) at 2023-04-10 09:18:46 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: No)
    Attachment (v3-0001-pg_upgrade-Add-include-logical-replication-slots-.patch) at 2023-04-10 09:16:09 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v2-0001-pg_upgrade-Add-include-replication-slots-option.patch) at 2023-04-07 13:59:58 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (0001-pg_upgrade-Add-include-replication-slot-option.patch) at 2023-04-04 07:00:01 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
History
When Who What
2023-11-22 08:46:57 Amit Kapila (amitkapila) Closed in commitfest 2023-11 with status: Committed
2023-11-22 08:46:57 Amit Kapila (amitkapila) Changed committer to amitkapila
2023-10-24 07:50:19 Bharath Rupireddy (bharathrupireddy) New status: Ready for Committer
2023-10-03 04:42:12 Bharath Rupireddy (bharathrupireddy) Added bharathrupireddy as reviewer
2023-10-02 11:08:06 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Moved to next CF
2023-08-02 19:29:40 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2023-07 with status: Moved to next CF
2023-05-17 00:06:56 Peter Smith (smithpb2250) Changed reviewers to Peter Smith (smithpb2250)
2023-04-14 05:44:40 Hayato Kuroda (ha-kun) Changed targetversion to 17
2023-04-12 07:51:02 Hayato Kuroda (ha-kun) Changed authors to Hayato Kuroda (ha-kun)
2023-04-12 07:50:52 Hayato Kuroda (ha-kun) Attached mail thread TYAPR01MB58664C81887B3AF2EB6B16E3F5939@TYAPR01MB5866.jpnprd01.prod.outlook.com
2023-04-12 07:50:52 Hayato Kuroda (ha-kun) Created patch record
Edit