From: | rajesh singarapu <rajesh(dot)rs0541(at)gmail(dot)com> |
---|---|
To: | Dilip Kumar <dilipbalaut(at)gmail(dot)com> |
Cc: | Zheng Li <zhengli10(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org> |
Subject: | Re: Support logical replication of DDLs |
Date: | 2022-03-15 06:27:28 |
Message-ID: | CADgiWi5aDwV+o+P_c62pLBxsZ01BK-R8KbmuPbPOfrAwAw4ptA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
+
On Sun, Mar 13, 2022 at 5:05 PM Dilip Kumar <dilipbalaut(at)gmail(dot)com> wrote:
>
> On Mon, Feb 21, 2022 at 9:43 PM Zheng Li <zhengli10(at)gmail(dot)com> wrote:
> >
> > Hello,
> >
> > One of the most frequently requested improvements from our customers
> > is to reduce downtime associated with software updates (both major and
> > minor versions). To do this, we have reviewed potential contributions to
> > improving logical replication.
> >
> > I’m working on a patch to support logical replication of data
> > definition language statements (DDLs). This is a useful feature when a
> > database in logical replication has lots of tables, functions and
> > other objects that change over time, such as in online cross major
> > version upgrade.
>
> +1
+1
> > I put together a prototype that replicates DDLs using the generic
> > messages for logical decoding. The idea is to log the candidate DDL
> > string in ProcessUtilitySlow() using LogLogicalMessge() with a new
> > flag in WAL record type xl_logical_message indicating it’s a DDL
> > message. The xl_logical_message record is decoded and sent to the
> > subscriber via pgoutput. The logical replication worker process is
> > dispatched for this new DDL message type and executes the command
> > accordingly.
>
> If you don't mind, would you like to share the POC or the branch for this work?
I would love to try this patch out, would you like to share branch or POC ?
From | Date | Subject | |
---|---|---|---|
Next Message | Shukla, Pranjal | 2022-03-15 06:42:55 | Re: Restoring using PG_DUMP in PG12 results in |
Previous Message | Michael Lewis | 2022-03-15 06:18:28 | Re: Indexes that would span partitions. |
From | Date | Subject | |
---|---|---|---|
Next Message | Bharath Rupireddy | 2022-03-15 06:49:47 | Re: Add checkpoint and redo LSN to LogCheckpointEnd log message |
Previous Message | Amit Langote | 2022-03-15 06:19:00 | Re: generic plans and "initial" pruning |