| From: | Fabrice Chapuis <fabrice636861(at)gmail(dot)com> |
|---|---|
| To: | Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> |
| Cc: | Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>, shveta malik <shveta(dot)malik(at)gmail(dot)com>, Alexander Kukushkin <cyberdemn(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com> |
| Subject: | Re: Issue with logical replication slot during switchover |
| Date: | 2025-11-19 12:02:37 |
| Message-ID: | CAA5-nLBWFyOqPsve6zf6NyLN_Z8cG=9fhaHWwzn7BLcxZ2kfBA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
The use of the *synced *flag could perhaps be a first step towards
distinguishing between a synchronization slot on a standby and a failover
slot created on a standby.
On the primary, *synced* should always be false.
On a secondary, actually *synced* remains true even if the parameter
sync_replication_slots parameter is set to 'off'.
Regards,
Fabrice
On Wed, Nov 19, 2025 at 1:56 AM Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
wrote:
> On Tue, Nov 18, 2025 at 1:30 AM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
> wrote:
> >
> > On Sat, Nov 15, 2025 at 4:02 AM Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com>
> wrote:
> > >
> > > On Fri, Nov 14, 2025 at 2:39 AM Amit Kapila <amit(dot)kapila16(at)gmail(dot)com>
> wrote:
> > > >
> > > >
> > > > The point is quite fundamental, do you think we can sync to a
> > > > pre-existing slot with the same name and failover marked as true
> after
> > > > the first time the node joins a new primary?
> > >
> > > Given the current behavior that we cannot create a logical slot with
> > > failover=true on the standby, it makes sense to me that we overwrite
> > > the pre-existing slot (with synced=false and failover=true) on the old
> > > primary by the slot (with synced=true and failover=true) on the new
> > > primary if their names, plugin and other properties matches and the
> > > pre-existing slot has lesser LSNs and XIDs than the one on the new
> > > primary. But at the same time, we need to consider the possible future
> > > changes that allow users to create a slot with failover=true also on
> > > the standby.
> > >
> > > Alexander pointed out[1] that allowing to create a slot with
> > > failover=true on the standby won't work with the current
> > > implementation. I agree with his analysis, and I guess we would need
> > > more changes than simply allowing it, regardless of accepting the
> > > proposed change. We might need to introduce a replication slot origin
> > > or a generation.
> > >
> >
> > AFAICS, the email you pointed out wrote about use cases, not the
> > actual code implementation. We can discuss use cases if we want to
> > pursue that implementation, but the reason why we decided not to allow
> > it was for the cases where users try to configure cascaded standbys to
> > also try to sync slots from the first standby that are already being
> > synced from the primary. There are quite a few technical challenges in
> > supporting that, like how to make sure primary waits even for cascaded
> > standbys before sending the changes to logical subscribers.
>
> Right. My point is that these are two independent issues. The fact
> that creating a slot with failover=true directly on a standby is
> difficult (due to the cascaded-standby cases you mentioned) does not,
> by itself, justify allowing us to overwrite an existing slot with
> failover=true and synced=false during slot synchronization.
>
> > OTOH, for the cases where there is a totally different logical slot on
> > standby (not present on primary) with failover=true, we can allow it
> > to be synced from standby-1 to a cascaded standby, though we need some
> > way to distinguish those cases. For example, during sync on cascaded
> > standby, we can ensure that the slot being synced is not a sync-slot
> > (failover=true and sync=true).
>
> Yes. We need some way to distinguish those slots, otherwise if users
> create a slot with the same name on the primary, the slot on standby-1
> (a cascading standby) could be overwritten. I think we would need some
> additional metadata per slot to support that safely.
>
> Regards,
>
> --
> Masahiko Sawada
> Amazon Web Services: https://aws.amazon.com
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David Geier | 2025-11-19 12:28:51 | Re: Performance issues with parallelism and LIMIT |
| Previous Message | Dagfinn Ilmari Mannsåker | 2025-11-19 11:56:28 | Re: gen_guc_tables.pl: Validate required GUC fields before code generation |