Re: Support logical replication of DDLs

From: Ajin Cherian <itsajin(at)gmail(dot)com>
To: rajesh singarapu <rajesh(dot)rs0541(at)gmail(dot)com>
Cc: Zheng Li <zhengli10(at)gmail(dot)com>, li jie <ggysxcq(at)gmail(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, Peter Smith <smithpb2250(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, "houzj(dot)fnst(at)fujitsu(dot)com" <houzj(dot)fnst(at)fujitsu(dot)com>, Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>, Japin Li <japinli(at)hotmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Support logical replication of DDLs
Date: 2022-11-29 04:44:42
Message-ID: CAFPTHDZFn-zoH+fWqPqniY6GiHiqHqK=4P4tGBYXDB317zRg1A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Tue, Nov 29, 2022 at 3:39 PM rajesh singarapu
<rajesh(dot)rs0541(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message rajesh singarapu 2022-11-29 05:05:32 Re: Support logical replication of DDLs
Previous Message rajesh singarapu 2022-11-29 04:39:33 Re: Support logical replication of DDLs

Browse pgsql-hackers by date

  From Date Subject
Next Message houzj.fnst@fujitsu.com 2022-11-29 04:48:28 RE: Perform streaming logical transactions by background workers and parallel apply
Previous Message rajesh singarapu 2022-11-29 04:39:33 Re: Support logical replication of DDLs