Support logical replication of DDL commands

Edit

Title

Topic

Replication & Recovery

Created

2022-03-17 19:36:44

Last modified

2023-01-23 22:31:56 (4 days, 7 hours ago)

Latest email

2023-01-24 03:27:50 (4 days, 2 hours ago)

Status

2023-01: Needs review

2022-11: Moved to next CF

2022-09: Moved to next CF

2022-07: Moved to next CF

Target version

Authors

Runqi Tian (runqitian), vignesh C (vignesh.postgres), Ajin Cherian (ajinc), Hou Zhijie (houzj), Zheng Li (zhengli)

Reviewers

Peter Smith (smithpb2250)Become reviewer

Committer

Links

Git

Emails

Support logical replication of DDLs: First at 2022-02-21 15:53:43 by Zheng Li <zhengli10 at gmail.com>
Latest at 2023-01-24 03:27:50 by Zheng Li <zhengli10 at gmail.com>
Latest attachment (v63-0001-Infrastructure-to-support-DDL-deparsing.patch) at 2023-01-19 08:51:01 from vignesh C <vignesh21 at gmail.com>
    Attachment (v63-0001-Infrastructure-to-support-DDL-deparsing.patch) at 2023-01-19 08:51:01 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v62-0002-Functions-to-deparse-Table-DDL-commands.patch) at 2023-01-16 13:33:49 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v61-0001-Infrastructure-to-support-DDL-deparsing.patch) at 2023-01-13 06:33:26 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v60-0004-Introduce-the-test_ddl_deparse_regress-test-module.patch) at 2023-01-07 15:28:11 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (v59-0005-Support-DDL-replication.patch) at 2023-01-04 21:35:07 from Zheng Li <zhengli10 at gmail.com> (Patch: No)
    Attachment (v58-0004-DDL-messaging-infrastructure-for-DDL-replication.patch) at 2022-12-28 22:42:43 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (v57-0003-Introduce-the-test_ddl_deparse_regress-test-module.patch) at 2022-12-27 22:32:59 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (v56-0004-DDL-messaging-infrastructure-for-DDL-replication.patch) at 2022-12-27 12:03:38 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v56-0001-Infrastructure-to-support-DDL-deparsing.patch) at 2022-12-27 06:13:53 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v55-0001-Infrastructure-to-support-DDL-deparsing.patch) at 2022-12-21 17:21:51 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v54-0005-Skip-ALTER-TABLE-subcommands-generated-for-TableLike.patch) at 2022-12-19 21:25:59 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (v53-0002-Support-DDL-replication.patch) at 2022-12-19 13:19:14 from Ajin Cherian <itsajin at gmail.com> (Patch: No)
    Attachment (v52-0005-Skip-ALTER-TABLE-subcommands-generated-for-Table.patch) at 2022-12-15 16:24:44 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v51-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch) at 2022-12-15 05:36:41 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (v50-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch) at 2022-12-14 10:34:44 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v50-0004-Test-cases-for-DDL-replication.patch) at 2022-12-13 22:25:48 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (v49-0004-Test-cases-for-DDL-replication.patch) at 2022-12-13 09:17:32 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v48-0004-Test-cases-for-DDL-replication.patch) at 2022-12-12 22:49:26 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (v47-0005-Skip-ALTER-TABLE-subcommands-generated-for-TableLike.patch) at 2022-12-12 17:40:19 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (v46-0004-Test-cases-for-DDL-replication.patch) at 2022-12-12 13:13:55 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v45-0002-Support-DDL-replication.patch) at 2022-12-12 04:58:27 from Zheng Li <zhengli10 at gmail.com> (Patch: No)
    Attachment (v45-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch) at 2022-12-07 11:22:19 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v44-0002-Support-DDL-replication.patch) at 2022-12-06 18:52:29 from vignesh C <vignesh21 at gmail.com> (Patch: No)
    Attachment (v43-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch) at 2022-12-02 23:48:59 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (v42-0005-Skip-ALTER-TABLE-subcommands-generated-for-TableLike.patch) at 2022-12-02 02:46:25 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (v41-0002-Support-DDL-replication.patch) at 2022-11-29 18:31:49 from vignesh C <vignesh21 at gmail.com> (Patch: No)
    Attachment (v40-0002-Support-DDL-replication.patch) at 2022-11-28 04:47:39 from Zheng Li <zhengli10 at gmail.com> (Patch: No)
    Attachment (v40-0002-Support-DDL-replication.patch) at 2022-11-28 03:28:57 from Zheng Li <zhengli10 at gmail.com> (Patch: No)
    Attachment (v40-0004-Test-cases-for-DDL-replication.patch) at 2022-11-25 10:30:39 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v39-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch) at 2022-11-20 03:59:47 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v38-0004-Test-cases-for-DDL-replication.patch) at 2022-11-17 19:01:50 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (v37-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch) at 2022-11-16 08:57:14 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v36-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch) at 2022-11-14 06:33:18 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v36-0004-Test-cases-for-DDL-replication.patch) at 2022-11-11 14:39:17 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v35-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch) at 2022-11-10 04:04:49 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v34-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch) at 2022-11-08 04:03:34 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v33-0001-Functions-to-deparse-DDL-commands.patch) at 2022-10-27 10:32:21 from vignesh C <vignesh21 at gmail.com> (Patch: No)
    Attachment (v32-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch) at 2022-10-26 20:39:24 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (v31-0004-Test-cases-for-DDL-replication.patch) at 2022-10-24 12:29:34 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v30-0001-Functions-to-deparse-DDL-commands.patch) at 2022-10-19 05:48:05 from vignesh C <vignesh21 at gmail.com> (Patch: No)
    Attachment (v29-0004-Test-cases-for-DDL-replication.patch) at 2022-10-18 01:08:55 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (v28-0004-Test-cases-for-DDL-replication.patch) at 2022-10-17 06:11:06 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v28-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch) at 2022-10-13 12:46:39 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v27-0004-Test-cases-for-DDL-replication.patch) at 2022-10-11 13:30:37 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v26-0004-Test-cases-for-DDL-replication.patch) at 2022-10-10 09:58:48 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v25-0004-Test-cases-for-DDL-replication.patch) at 2022-10-07 05:07:20 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v25-0004-Test-cases-for-DDL-replication.patch) at 2022-10-07 02:40:25 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (v25-0002-Support-DDL-replication.patch) at 2022-10-06 21:30:09 from Zheng Li <zhengli10 at gmail.com> (Patch: No)
    Attachment (v25-0005-Add-DDL-deparser-support-for-TEXT-SEARCH-commands-wh.patch) at 2022-10-06 16:40:10 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (v24-0004-Test-cases-for-DDL-replication.patch) at 2022-09-30 07:47:13 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v23-0001-Functions-to-deparse-DDL-commands.patch) at 2022-09-26 10:26:07 from vignesh C <vignesh21 at gmail.com> (Patch: Yes)
    Attachment (v23-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch) at 2022-09-21 16:55:35 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (v22-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch) at 2022-09-20 14:57:44 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v21-0004-Test-cases-for-DDL-replication.patch) at 2022-09-15 12:38:19 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v20-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch) at 2022-09-05 14:18:30 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v19-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch) at 2022-08-29 06:14:57 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v18-0001-Functions-to-deparse-DDL-commands.patch) at 2022-08-16 11:57:17 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v17-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch) at 2022-08-13 15:26:30 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v16-0004-Test-cases-for-DDL-replication.patch) at 2022-08-04 02:51:59 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v15-0004-Test-cases-for-DDL-replication.patch) at 2022-08-02 03:20:55 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v14-0001-Functions-to-deparse-DDL-commands.patch) at 2022-07-28 03:48:11 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (0005-Support-replication-of-global-object-commands-these-.patch) at 2022-07-22 21:18:56 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (v13-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch) at 2022-07-20 12:28:26 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v12-0004-Test-cases-for-DDL-replication.patch) at 2022-07-12 09:03:33 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v11-0004-Test-cases-for-DDL-replication.patch) at 2022-07-05 08:28:05 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v10-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch) at 2022-06-29 09:54:40 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (0001-WIP-Add-regression-tests-for-DDL-deparse.patch) at 2022-06-22 05:38:36 from Masahiko Sawada <sawada.mshk at gmail.com> (Patch: Yes)
    Attachment (v9-0002-Support-DDL-replication.patch) at 2022-06-21 12:19:15 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: No)
    Attachment (0003-Logical-replication-of-DDL-messages.patch) at 2022-06-17 19:38:03 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (0004-Enable-replication-of-CREATE-MATERIALIZED-VIEW-AS-st.patch) at 2022-06-12 06:46:27 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (v8-0004-Test-cases-for-DDL-replication.patch) at 2022-06-09 11:43:51 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v7-0002-Support-DDL-replication.patch) at 2022-06-07 02:59:31 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: No)
    Attachment (v6-0001-Functions-to-deparse-DDL-commands.patch) at 2022-06-02 12:14:00 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v5-0001-Functions-to-deparse-DDL-commands.patch) at 2022-05-27 09:07:46 from "houzj.fnst at fujitsu.com" <houzj.fnst at fujitsu.com> (Patch: Yes)
    Attachment (v5-0001-Functions-to-deparse-DDL-commands.patch) at 2022-05-26 05:45:47 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (0005-Support-replication-of-CREATE-.-AS-.-and-SELECT-.-IN.patch) at 2022-05-13 21:01:33 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Functions-to-deparse-DDL-commands.patch) at 2022-05-11 06:21:59 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Functions-to-deparse-DDL-commands.patch) at 2022-05-10 15:17:27 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v2-0001-Fix-race-in-032_relfilenode_reuse.pl.patch) at 2022-05-10 11:33:49 from Ajin Cherian <itsajin at gmail.com> (Patch: Yes)
    Attachment (v1-0001-Functions-to-deparse-DDL-commands.patch) at 2022-05-06 13:24:14 from Amit Kapila <amit.kapila16 at gmail.com> (Patch: Yes)
    Attachment (0008-Fail-replication-worker-on-DDL-command-that-rewrites.patch) at 2022-04-29 17:34:32 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (v4-0007-Enable-logging-and-replication-of-DDLs-in-function.patch) at 2022-04-15 02:08:58 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (v4-0005-Support-replication-of-CREATE-.-AS-.-and-SELECT-.-IN.patch) at 2022-04-13 17:22:46 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (v3-0001-Define-DDL-replication-levels-via-the-CREATE-PUBL.patch) at 2022-03-23 05:09:10 from Japin Li <japinli at hotmail.com> (Patch: Yes)
    Attachment (0001-syntax-pg_publication-pg_dump-ddl_replication.patch) at 2022-03-18 00:18:18 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)
    Attachment (ddl_replication.patch1) at 2022-03-16 21:17:18 from Zheng Li <zhengli10 at gmail.com> (Patch: Yes)

History

When	Who	What
2023-01-23 22:31:56	Zheng Li (zhelli)	New status: Needs review
2022-12-08 13:47:43	Ian Barwick (barwick)	Closed in commitfest 2022-11 with status: Moved to next CF
2022-12-06 01:07:34	Zheng Li (zhelli)	Changed authors to Zheng Li (zhengli), vignesh C (vignesh.postgres), Ajin Cherian (ajinc), Hou Zhijie (houzj), Runqi Tian (runqitian)
2022-11-03 22:27:21	Peter Smith (smithpb2250)	Added smithpb2250 as reviewer
2022-10-28 00:25:38	Zheng Li (zhelli)	Changed authors to Zheng Li (zhengli), vignesh C (vignesh.postgres), Ajin Cherian (ajinc), Hou Zhijie (houzj)
2022-10-12 06:01:44	Michael Paquier (michael-kun)	Closed in commitfest 2022-09 with status: Moved to next CF
2022-08-01 21:34:06	Jacob Champion (jchampion)	New status: Waiting on Author
2022-08-01 21:34:01	Jacob Champion (jchampion)	Closed in commitfest 2022-07 with status: Moved to next CF
2022-03-18 17:30:00	Zheng Li (zhengli)	Changed gitlink to https://github.com/zli236/postgres/tree/ddl_replication
2022-03-18 17:29:07	Zheng Li (zhengli)	Posted comment with messageid <164762454752.1210.2939511148604659322.pgcf@coridan.postgresql.org>
2022-03-17 19:37:37	Zheng Li (zhengli)	Changed authors to Zheng Li (zhengli)
2022-03-17 19:37:37	Zheng Li (zhengli)	Changed targetversion to 16
2022-03-17 19:36:44	Zheng Li (zhengli)	Attached mail thread CAAD30U+pVmfKwUKy8cbZOnUXyguJ-uBNejwD75Kyo=OjdQGJ9g@mail.gmail.com
2022-03-17 19:36:44	Zheng Li (zhengli)	Created patch record

Edit