Re: Dropping publication breaks logical replication - Mailing list pgsql-hackers

From Ashutosh Bapat
Subject Re: Dropping publication breaks logical replication
Date
Msg-id CAExHW5voT15FLfm70U4pqwVgTJQGPMTtvNaH+qeppK4DKvKh6A@mail.gmail.com
Whole thread Raw
In response to Re: Dropping publication breaks logical replication  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: Dropping publication breaks logical replication
List pgsql-hackers
On Tue, Aug 5, 2025 at 9:50 AM Amit Kapila <amit.kapila16@gmail.com> wrote:
>
> On Fri, Aug 1, 2025 at 5:06 PM Ashutosh Bapat
> <ashutosh.bapat.oss@gmail.com> wrote:
> >
> > On Fri, Aug 1, 2025 at 4:03 PM Amit Kapila <amit.kapila16@gmail.com> wrote:
> > >
> > > Now, seeing this report, it seems the customer(s) are probably okay to
> > > skip a missing publication and let replication continue. So, we should
> > > consider backpatching this change but it would be better if few more
> > > people can share their opinion on this matter.
> >
> > Including Tomas for his opinion. Who else do you think can provide an
> > opinion based on experience?
> >
>
> I don't have any particular names in mind but Dilip and Sawada-San
> names are listed as reviewers in the commit [1], so it would be good
> to see what are their thoughts on this.
>
> Please note that this behavior is from the time logical replication
> was introduced, so we need to be a bit careful in changing the
> behavior in backbranches.

Agreed.

Only Dilip has expressed an opinion so far. Haven't heard from others,
so can't guess what their opinions are.

If we are ok backpatching it, I will review Vignesh's patches thoroughly.

--
Best Wishes,
Ashutosh Bapat



pgsql-hackers by date:

Previous
From: Ashutosh Bapat
Date:
Subject: Re: Allow REPLICA IDENTITY with CREATE TABLE statement
Next
From: Amit Kapila
Date:
Subject: Re: Dropping publication breaks logical replication