| 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-05 04:20:09 |
| Message-ID: | CAA4eK1JMn8x2hGU9W_tgqFz0dYVE3Ro6HQEL7HHXiZ2_ZC=FvA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
--
With Regards,
Amit Kapila.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | vignesh C | 2025-08-05 04:28:33 | Re: CREATE PUBLICATION with 'publish_generated_columns' parameter specified but unassigned |
| Previous Message | Corey Huinker | 2025-08-05 04:10:33 | Re: CAST(... ON DEFAULT) - WIP build on top of Error-Safe User Functions |