MIME-Version: 1.0
References: 
 <CAAD30U+pVmfKwUKy8cbZOnUXyguJ-uBNejwD75Kyo=OjdQGJ9g@mail.gmail.com>
 <CAFiTN-tM1zOk50xoeP5vdzaO0U_iQ3u8oZ2P1L7J=0ka+c7Utw@mail.gmail.com>
In-Reply-To: 
 <CAFiTN-tM1zOk50xoeP5vdzaO0U_iQ3u8oZ2P1L7J=0ka+c7Utw@mail.gmail.com>
From: rajesh singarapu <rajesh.rs0541@gmail.com>
Date: Tue, 15 Mar 2022 11:57:28 +0530
Message-ID: 
 <CADgiWi5aDwV+o+P_c62pLBxsZ01BK-R8KbmuPbPOfrAwAw4ptA@mail.gmail.com>
Subject: Re: Support logical replication of DDLs
To: Dilip Kumar <dilipbalaut@gmail.com>
Cc: Zheng Li <zhengli10@gmail.com>,
	PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/CADgiWi5aDwV%2Bo%2BP_c62pLBxsZ01BK-R8KbmuPbPOfrAwAw4ptA%40mail.gmail.com>
Precedence: bulk

+

On Sun, Mar 13, 2022 at 5:05 PM Dilip Kumar <dilipbalaut@gmail.com> wrote:
>
> On Mon, Feb 21, 2022 at 9:43 PM Zheng Li <zhengli10@gmail.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 t=
o
> > improving logical replication.
> >
> > I=E2=80=99m 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=E2=80=99s a DD=
L
> > 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 ?