Re: Dropping publication breaks logical replication

From: Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
To: Ashutosh Bapat <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com>
Cc: Tomas Vondra <tomas(at)vondra(dot)me>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, vignesh C <vignesh21(at)gmail(dot)com>, Dilip Kumar <dilipbalaut(at)gmail(dot)com>, Sawada Masahiko <sawada(dot)mshk(at)gmail(dot)com>
Subject: Re: Dropping publication breaks logical replication
Date: 2025-08-08 12:48:34
Message-ID: CAA4eK1+eCYm7US_vvZDW8wotjfG0+5dWdOB+rQoOWPsf7hzU_g@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, Aug 8, 2025 at 5:19 PM Ashutosh Bapat
<ashutosh(dot)bapat(dot)oss(at)gmail(dot)com> wrote:
>
> On Tue, Aug 5, 2025 at 9:50 AM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com> wrote:
> >
> > On Fri, Aug 1, 2025 at 5:06 PM Ashutosh Bapat
> > <ashutosh(dot)bapat(dot)oss(at)gmail(dot)com> wrote:
> > >
> > > On Fri, Aug 1, 2025 at 4:03 PM Amit Kapila <amit(dot)kapila16(at)gmail(dot)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.
>

Yeah, let's wait for a few more days. Even if we decide to backpatch
it, let's target the next minor release.

--
With Regards,
Amit Kapila.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Ashutosh Bapat 2025-08-08 13:21:59 Re: Improve pg_sync_replication_slots() to wait for primary to advance
Previous Message Ashutosh Bapat 2025-08-08 11:48:55 Re: Dropping publication breaks logical replication