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

From Ajin Cherian
Subject Re: Support logical replication of DDLs
Date
Msg-id CAFPTHDZFn-zoH+fWqPqniY6GiHiqHqK=4P4tGBYXDB317zRg1A@mail.gmail.com
Whole thread Raw
In response to Re: Support logical replication of DDLs  (rajesh singarapu <rajesh.rs0541@gmail.com>)
Responses Re: Support logical replication of DDLs
List pgsql-hackers
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: rajesh singarapu
Date:
Subject: Re: Support logical replication of DDLs
Next
From: "houzj.fnst@fujitsu.com"
Date:
Subject: RE: Perform streaming logical transactions by background workers and parallel apply