Preserve subscription relation state during pg_upgrade

Edit

Title

Topic

Replication & Recovery

Created

2023-02-22 06:44:37

Last modified

2024-01-04 10:07:36 (8 months, 2 weeks ago)

Latest email

2024-07-25 08:16:58 (1 month, 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

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