public inbox for [email protected]  

help / color / mirror / Atom feed
From: David G. Johnston <[email protected]>
To: Amit Kapila <[email protected]>
Cc: [email protected] <[email protected]>
Cc: [email protected] <[email protected]>
Subject: Re: Logical Replication upgrade
Date: Thu, 16 Apr 2026 21:29:09 -0700
Message-ID: <CAKFQuwaiNUyhacvShObSTA2=p_YxWj_AKa+byki6nxS6jYhjuA@mail.gmail.com> (raw)
In-Reply-To: <CAA4eK1LWNPW7bTY+0=L183rCyqUmq6MuFkgTE8QwHeT6nkDmpg@mail.gmail.com>
References: <[email protected]>
	<CAKFQuwZ86BE49-gzFunuu=u1ieT+T6q900=1Cx=vuO9Aqv9kcg@mail.gmail.com>
	<CAA4eK1LR_MjZuV31r-MOqno9-Kr0mA9zas2cxZtE=+X3RUYXbw@mail.gmail.com>
	<CAKFQuwbHjB6EEdp6mmaUt4bCTYrYUdvEr44vVqhdT0OD4Z+3Qg@mail.gmail.com>
	<CAA4eK1+dR-sEGM+oC7H_-7PrBJBcdM2o5-eS6JrkMBJ0FOA54Q@mail.gmail.com>
	<CAKFQuwaWUuXJYZSMKtiXFT=kFK-sFg+pSwK0MUN-MBEEobkfBg@mail.gmail.com>
	<CAA4eK1LWNPW7bTY+0=L183rCyqUmq6MuFkgTE8QwHeT6nkDmpg@mail.gmail.com>

On Thu, Apr 16, 2026 at 8:55 PM Amit Kapila <[email protected]> wrote:

> On Thu, Apr 16, 2026 at 11:16 AM David G. Johnston
> <[email protected]> wrote:
> >
> > On Wednesday, April 15, 2026, Amit Kapila <[email protected]>
> wrote:
> >>
> >>
> >> So, how about: "All slots on the old cluster must be usable, i.e.,
> >> their pg_replication_slots.conflicting is false."?
> >
> >
> > That works.
> >
> > Then we’d also change:
> >
> > The new cluster must not have permanent logical slots, i.e., there must
> be no slots where pg_replication_slots.temporary is false.
> >
> > To be:
> >
> > “The new cluster is only permitted to have temporary logical slots,
> i.e., ones where pg_replication_slots.temporary is true.”
> >
>
> What you wrote is correct but it is better to keep what is not allowed
> for this case. Based on that, how about the following:
> "The new cluster must not have any permanent logical slots; i.e., any
> existing logical slots must have pg_replication_slots.temporary set to
> true."
>
>
I was like 51/49 for flipping that around, so sure.

David J.


view thread (10+ messages)  latest in thread

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected], [email protected]
  Subject: Re: Logical Replication upgrade
  In-Reply-To: <CAKFQuwaiNUyhacvShObSTA2=p_YxWj_AKa+byki6nxS6jYhjuA@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox