MIME-Version: 1.0
References: <177609278737.403059.14174275013090471947@wrigleys.postgresql.org>
 <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>
In-Reply-To: 
 <CAA4eK1LWNPW7bTY+0=L183rCyqUmq6MuFkgTE8QwHeT6nkDmpg@mail.gmail.com>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Thu, 16 Apr 2026 21:29:09 -0700
Message-ID: 
 <CAKFQuwaiNUyhacvShObSTA2=p_YxWj_AKa+byki6nxS6jYhjuA@mail.gmail.com>
Subject: Re: Logical Replication upgrade
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: "mimidatabase@gmail.com" <mimidatabase@gmail.com>,
	"pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000002d9ef6064fa06665"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwaiNUyhacvShObSTA2%3Dp_YxWj_AKa%2Bbyki6nxS6jYhjuA%40mail.gmail.com>
Precedence: bulk

--0000000000002d9ef6064fa06665
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Thu, Apr 16, 2026 at 8:55=E2=80=AFPM Amit Kapila <amit.kapila16@gmail.co=
m> wrote:

> On Thu, Apr 16, 2026 at 11:16=E2=80=AFAM David G. Johnston
> <david.g.johnston@gmail.com> wrote:
> >
> > On Wednesday, April 15, 2026, Amit Kapila <amit.kapila16@gmail.com>
> 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=E2=80=99d 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:
> >
> > =E2=80=9CThe new cluster is only permitted to have temporary logical sl=
ots,
> i.e., ones where pg_replication_slots.temporary is true.=E2=80=9D
> >
>
> 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.

--0000000000002d9ef6064fa06665
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr"><div class=3D"gmail_default" style=3D"fon=
t-family:arial,helvetica,sans-serif"><span style=3D"font-family:Arial,Helve=
tica,sans-serif">On Thu, Apr 16, 2026 at 8:55=E2=80=AFPM Amit Kapila &lt;<a=
 href=3D"mailto:amit.kapila16@gmail.com">amit.kapila16@gmail.com</a>&gt; wr=
ote:</span></div></div><div class=3D"gmail_quote gmail_quote_container"><bl=
ockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-lef=
t:1px solid rgb(204,204,204);padding-left:1ex">On Thu, Apr 16, 2026 at 11:1=
6=E2=80=AFAM David G. Johnston<br>
&lt;<a href=3D"mailto:david.g.johnston@gmail.com" target=3D"_blank">david.g=
.johnston@gmail.com</a>&gt; wrote:<br>
&gt;<br>
&gt; On Wednesday, April 15, 2026, Amit Kapila &lt;<a href=3D"mailto:amit.k=
apila16@gmail.com" target=3D"_blank">amit.kapila16@gmail.com</a>&gt; wrote:=
<br>
&gt;&gt;<br>
&gt;&gt;<br>
&gt;&gt; So, how about: &quot;All slots on the old cluster must be usable, =
i.e.,<br>
&gt;&gt; their pg_replication_slots.conflicting is false.&quot;?<br>
&gt;<br>
&gt;<br>
&gt; That works.<br>
&gt;<br>
&gt; Then we=E2=80=99d also change:<br>
&gt;<br>
&gt; The new cluster must not have permanent logical slots, i.e., there mus=
t be no slots where pg_replication_slots.temporary is false.<br>
&gt;<br>
&gt; To be:<br>
&gt;<br>
&gt; =E2=80=9CThe new cluster is only permitted to have temporary logical s=
lots, i.e., ones where pg_replication_slots.temporary is true.=E2=80=9D<br>
&gt;<br>
<br>
What you wrote is correct but it is better to keep what is not allowed<br>
for this case. Based on that, how about the following:<br>
&quot;The new cluster must not have any permanent logical slots; i.e., any<=
br>
existing logical slots must have pg_replication_slots.temporary set to<br>
true.&quot;<br><br></blockquote><div><br></div><div class=3D"gmail_default"=
 style=3D"font-family:arial,helvetica,sans-serif">I was like 51/49 for flip=
ping that around, so sure.</div><div class=3D"gmail_default" style=3D"font-=
family:arial,helvetica,sans-serif"><br></div><div class=3D"gmail_default" s=
tyle=3D"font-family:arial,helvetica,sans-serif">David J.</div><div class=3D=
"gmail_default" style=3D"font-family:arial,helvetica,sans-serif"><br></div>=
</div></div>

--0000000000002d9ef6064fa06665--