From: | rajesh singarapu <rajesh(dot)rs0541(at)gmail(dot)com> |
---|---|
To: | Ajin Cherian <itsajin(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:39:33 |
Message-ID: | CADgiWi49b_NYZOYZ8xBQM0JV887_Vta5q53cHF5ZArzNf9hd4w@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
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
On Tue, Nov 29, 2022 at 9:55 AM Ajin Cherian <itsajin(at)gmail(dot)com> wrote:
>
> On Tue, Nov 29, 2022 at 1:29 PM rajesh singarapu
> <rajesh(dot)rs0541(at)gmail(dot)com> wrote:
> >
> > One question,
> >
> > I understand that we create/enable triggers on create publication command flow.
> > I am wondering how this works in case of logical replication using slots.
> >
> >
> > thanks
> > Rajesh
> >
> Rajesh,
>
> The triggers functions when invoked write these ddl commands to WAL
> and the logical decoding WAL sender which is
> registered for that replication slot decodes the WAL logged DDL
> commands and sends them as logical replication
> messages to the subscriber side. The apply worker on the subscriber
> side, then converts these messages to actual
> DDL commands and executes them.
>
> regards,
> Ajin Cherian
> Fujitsu Australia
From | Date | Subject | |
---|---|---|---|
Next Message | Ajin Cherian | 2022-11-29 04:44:42 | Re: Support logical replication of DDLs |
Previous Message | Ajin Cherian | 2022-11-29 04:25:35 | Re: Support logical replication of DDLs |
From | Date | Subject | |
---|---|---|---|
Next Message | Ajin Cherian | 2022-11-29 04:44:42 | Re: Support logical replication of DDLs |
Previous Message | John Naylor | 2022-11-29 04:37:38 | Re: [PoC] Improve dead tuple storage for lazy vacuum |