| 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:25:35 |
| Message-ID: | CAFPTHDbunLJ8MA5gJ9Ym89EFAHfW7=nSOi42k9jQG+Z4ZgT1Fg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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 | rajesh singarapu | 2022-11-29 04:39:33 | Re: Support logical replication of DDLs |
| Previous Message | rajesh singarapu | 2022-11-29 02:29:03 | Re: Support logical replication of DDLs |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2022-11-29 04:34:56 | Re: Collation version tracking for macOS |
| Previous Message | Dilip Kumar | 2022-11-29 04:07:51 | Re: Avoid streaming the transaction which are skipped (in corner cases) |