Preserve subscription relation state during pg_upgrade

Edit
ID 4199
Title Preserve subscription relation state during pg_upgrade
Topic Replication & Recovery
Created 2023-02-22 06:44:37
Last modified 2024-01-04 10:07:36 (10 months, 2 weeks ago)
Latest email 2024-07-25 08:16:58 (3 months, 3 weeks ago)
Status
2024-01: Committed
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
Authors Julien Rouhaud (rjuju), vigneshwaran C (vignesh.postgres)
Reviewers Michael Paquier (michael-kun)Become reviewer
Committer Amit Kapila (amitkapila)
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/4199
git checkout commitfest/cf/4199
Emails
pg_upgrade and logical replication
First at 2023-02-17 07:54:33 by Julien Rouhaud <rjuju123 at gmail.com>
Latest at 2024-07-25 08:16:58 by Michael Paquier <michael at paquier.xyz>
Latest attachment (v3-0001-pg_upgrade-retrieve-subscription-count-more-effic.patch) at 2024-07-23 19:55:28 from Nathan Bossart <nathandbossart at gmail.com>
    Attachment (v3-0001-pg_upgrade-retrieve-subscription-count-more-effic.patch) at 2024-07-23 19:55:28 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v2-0001-pg_upgrade-retrieve-subscription-count-more-effic.patch) at 2024-07-22 14:46:29 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v1-0001-pg_upgrade-retrieve-subscription-count-more-effic.patch) at 2024-07-21 02:03:07 from Nathan Bossart <nathandbossart at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Fix-random-upgrade-failure-test-in-004_subscripti.patch) at 2024-03-27 06:27:29 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Fix-testcase.patch) at 2024-02-19 01:24:35 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v4-0001-Fix-testcase.patch) at 2024-02-16 05:20:33 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v3-0001-Fix-testcase.patch) at 2024-02-16 02:52:01 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v2-0001-Fix-testcase.patch) at 2024-02-14 05:21:54 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (0001-Fix-testcase.patch) at 2024-02-14 03:37:03 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: Yes)
    Attachment (v26-0001-Allow-upgrades-to-preserve-the-full-subscription.patch) at 2023-12-28 10:29:04 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v25-0001-Allow-upgrades-to-preserve-the-full-subscription.patch) at 2023-12-13 06:39:25 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v24-0001-Allow-upgrades-to-preserve-the-full-subscription.patch) at 2023-12-07 11:14:36 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v23-0001-Allow-upgrades-to-preserve-the-full-subscription.patch) at 2023-12-04 11:00:49 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v22-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-12-01 17:54:41 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v21-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-11-30 16:25:21 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (changes_by_amit_1.patch.txt) at 2023-11-29 09:32:02 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (v20-0002-Retain-the-subscription-oids-during-upgrade.patch) at 2023-11-28 10:42:23 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v19-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-11-25 01:51:04 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v19-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-11-24 15:35:26 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v18-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-11-23 08:43:45 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v17-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-11-22 11:55:16 from Shlok Kyal <shlok.kyal.oss at gmail.com> (Patch: Yes)
    Attachment (v16-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-11-21 17:33:36 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v15-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-11-19 03:38:39 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Retain-the-subscription-oids-during-upgrade.patch) at 2023-11-19 01:26:05 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (upgrade_retain_subscription_oid.patch) at 2023-11-19 01:22:09 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v14-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-11-15 18:03:28 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v13-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-11-10 13:56:18 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v12-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-11-08 06:21:06 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (0001-Added-GUC-hook-for-max_logical_replication_workers.patch) at 2023-11-03 10:45:45 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v11-0001-Preserve-the-full-subscription-s-state-during-pg.patch) at 2023-11-02 10:11:25 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v10-0001-Prevent-startup-of-logical-replication-launcher-.patch) at 2023-11-01 18:44:05 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v9_20231030-0001-Prevent-startup-of-logical-replication-launcher-i.patch) at 2023-10-30 09:35:09 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v9-0001-Prevent-startup-of-logical-replication-launcher-i.patch) at 2023-10-27 06:39:27 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (0001-Prevent-startup-of-logical-replication-launcher-in-b.patch) at 2023-09-25 01:57:28 from Michael Paquier <michael at paquier.xyz> (Patch: Yes)
    Attachment (v1-0001-Don-t-start-launcher-process-to-be-started-while-.patch) at 2023-09-19 13:44:49 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v8-0001-Don-t-start-launcher-process-in-binary-upgrade-mo.patch) at 2023-09-15 09:38:21 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (test.sh) at 2023-09-12 08:55:50 from "Hayato Kuroda (Fujitsu)" <kuroda.hayato at fujitsu.com> (Patch: No)
    Attachment (v7-0001-Preserve-the-full-subscription-s-state-during-pg_.patch) at 2023-09-11 10:31:52 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v6-0001-Optionally-preserve-the-full-subscription-s-state.patch) at 2023-09-06 10:58:39 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v5-0001-Optionally-preserve-the-full-subscription-s-state.patch) at 2023-04-24 07:22:24 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v4-0001-Optionally-preserve-the-full-subscription-s-state.patch) at 2023-04-07 02:28:02 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Optionally-preserve-the-full-subscription-s-state.patch) at 2023-03-27 08:49:55 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Optionally-preserve-the-full-subscription-s-state.patch) at 2023-03-09 08:34:56 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
    Attachment (v1-0001-POC-Preserve-the-subscription-relations-during-pg.patch) at 2023-02-22 06:43:18 from Julien Rouhaud <rjuju123 at gmail.com> (Patch: Yes)
History
When Who What
2024-01-04 10:07:36 vigneshwaran C (vignesh.postgres) Closed in commitfest 2024-01 with status: Committed
2024-01-04 10:07:36 vigneshwaran C (vignesh.postgres) Changed committer to amitkapila
2023-12-04 09:58:35 John Naylor (john.naylor) Closed in commitfest 2023-11 with status: Moved to next CF
2023-11-16 05:56:08 Michael Paquier (michael-kun) Added michael-kun as committer
2023-11-10 01:25:34 Michael Paquier (michael-kun) New status: Waiting on Author
2023-11-10 01:25:29 Michael Paquier (michael-kun) Changed authors to Julien Rouhaud (rjuju), vigneshwaran C (vignesh.postgres)
2023-11-03 08:03:55 John Naylor (john.naylor) New status: Needs review
2023-09-21 06:21:02 Michael Paquier (michael-kun) Closed in commitfest 2023-09 with status: Moved to next CF
2023-09-21 06:20:58 Michael Paquier (michael-kun) New status: Waiting on Author
2023-09-01 12:24:37 Peter Eisentraut (petere) Closed in commitfest 2023-09 with status: Returned with feedback
2023-08-02 07:42:35 Daniel Gustafsson (d_gustafsson) Closed in commitfest 2023-07 with status: Moved to next CF
2023-07-19 07:18:26 Michael Paquier (michael-kun) New status: Waiting on Author
2023-07-18 06:50:07 Michael Paquier (michael-kun) Added michael-kun as reviewer
2023-04-09 03:08:15 Greg Stark (stark) Closed in commitfest 2023-03 with status: Moved to next CF
2023-02-22 06:44:49 Julien Rouhaud (rjuju) Changed authors to Julien Rouhaud (rjuju)
2023-02-22 06:44:37 Julien Rouhaud (rjuju) Attached mail thread 20230217075433.u5mjly4d5cr4hcfe@jrouhaud
2023-02-22 06:44:37 Julien Rouhaud (rjuju) Created patch record
Edit