Re: Support logical replication of DDLs - Mailing list pgsql-hackers

From rajesh singarapu
Subject Re: Support logical replication of DDLs
Date
Msg-id CADgiWi69u=-9XFa98gjL-76b0_esgio2LVfzVsj9WyJr0yKY7w@mail.gmail.com
Whole thread Raw
In response to Re: Support logical replication of DDLs  (Ajin Cherian <itsajin@gmail.com>)
Responses Re: Support logical replication of DDLs
List pgsql-hackers
Thanks Ajin for the clarification.

This is really a helpful feature.

On Tue, Nov 29, 2022 at 10:14 AM Ajin Cherian <itsajin@gmail.com> wrote:
>
> On Tue, Nov 29, 2022 at 3:39 PM rajesh singarapu
> <rajesh.rs0541@gmail.com> wrote:
> >
> > Thanks Ajin for the reply.
> >
> > We "Create/Install" these trigger function at the time of "Create
> > publication", (CreatePublication())
> > but If I create a replication slot using something like "select * from
> > pg_create_logical_replication_slot('test1', 'test_decoding')"
> > we would not install these triggers in the system, so we dont get DDLs
> > decoded, right ?
> >
> > I am a bit new to this postgres, is there anything missing in my understanding ?
> >
> > thanks
> > Raejsh
> >
>
> Currently this feature is only supported using "Create publication".
> We have not added
> a slot level parameter to trigger this.
>
> regards,
> Ajin Cherian
> Fujitsu Australia



pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Collation version tracking for macOS
Next
From: "houzj.fnst@fujitsu.com"
Date:
Subject: RE: Perform streaming logical transactions by background workers and parallel apply