Support logical replication of DDL commands

Edit
Title Support logical replication of DDL commands
Topic Replication & Recovery
Created 2022-03-17 19:36:44
Last modified 2022-10-28 00:25:38 (1 month ago)
Latest email 2022-12-02 23:48:59 (7 hours, 6 minutes ago)
Status
2022-11: Waiting on Author
2022-09: Moved to next CF
2022-07: Moved to next CF
Target version 16
Authors Zheng Li (zhengli), vignesh C (vignesh.postgres), Ajin Cherian (ajinc), Hou Zhijie (houzj)
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 2022-12-02 23:48:59 by Zheng Li <zhengli10 at gmail.com>
Latest attachment (v43-0003-Support-CREATE-TABLE-AS-SELECT-INTO.patch) at 2022-12-02 23:48:59 from Zheng Li <zhengli10 at gmail.com>
    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
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