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 05:22:34 |
Message-ID: | CADgiWi7KXmGGZE9FigoWHhiCecyLf618kBq9brEVUF3kKZ=REQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
Isn't it a good idea to move triggers to CreateReplicationSlot() ? as
create publication also create replication slot, AFAIK.
thanks
Rajesh
On Tue, Nov 29, 2022 at 10:35 AM rajesh singarapu
<rajesh(dot)rs0541(at)gmail(dot)com> wrote:
>
> Thanks Ajin for the clarification.
>
> This is really a helpful feature.
>
> On Tue, Nov 29, 2022 at 10:14 AM Ajin Cherian <itsajin(at)gmail(dot)com> wrote:
> >
> > 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
From | Date | Subject | |
---|---|---|---|
Next Message | Ajin Cherian | 2022-11-29 06:39:29 | Re: Support logical replication of DDLs |
Previous Message | rajesh singarapu | 2022-11-29 05:05:32 | Re: Support logical replication of DDLs |
From | Date | Subject | |
---|---|---|---|
Next Message | Masahiko Sawada | 2022-11-29 05:41:18 | Re: Fix comment in SnapBuildFindSnapshot |
Previous Message | houzj.fnst@fujitsu.com | 2022-11-29 05:11:34 | RE: Perform streaming logical transactions by background workers and parallel apply |