MIME-Version: 1.0
In-Reply-To: 
 <CAA4eK1+dR-sEGM+oC7H_-7PrBJBcdM2o5-eS6JrkMBJ0FOA54Q@mail.gmail.com>
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>
From: "David G. Johnston" <david.g.johnston@gmail.com>
Date: Wed, 15 Apr 2026 22:46:06 -0700
Message-ID: 
 <CAKFQuwaWUuXJYZSMKtiXFT=kFK-sFg+pSwK0MUN-MBEEobkfBg@mail.gmail.com>
Subject: 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="00000000000047b724064f8d596c"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKFQuwaWUuXJYZSMKtiXFT%3DkFK-sFg%2BpSwK0MUN-MBEEobkfBg%40mail.gmail.com>
Precedence: bulk

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

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 slots,=
 i.e.,
ones where pg_replication_slots.temporary is true.=E2=80=9D

We could make it mirror the above one more closely, but as the former
mentions the old cluster and the later the new one, I kinda like the
different flow, less likely to skim over it.

David J.

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

On Wednesday, April 15, 2026, Amit Kapila &lt;<a href=3D"mailto:amit.kapila=
16@gmail.com" target=3D"_blank">amit.kapila16@gmail.com</a>&gt; wrote:<br><=
blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px=
 #ccc solid;padding-left:1ex"><br>
So, how about: &quot;All slots on the old cluster must be usable, i.e.,<br>
their pg_replication_slots.conflicti<wbr>ng is false.&quot;?<br>
</blockquote><div><br></div><div>That works.</div><div><br></div><div>Then =
we=E2=80=99d also change:</div><div><br></div><div><font face=3D"Open Sans,=
 sans-serif"><span style=3D"font-size:14.4px">The new cluster must not have=
 permanent logical slots, i.e., there must be no slots where pg_replication=
_slots.temporary is false.</span></font></div><div><font face=3D"Open Sans,=
 sans-serif"><span style=3D"font-size:14.4px"><br></span></font></div><div>=
<font face=3D"Open Sans, sans-serif"><span style=3D"font-size:14.4px">To be=
:</span></font></div><div><font face=3D"Open Sans, sans-serif"><span style=
=3D"font-size:14.4px"><br></span></font></div><div><font face=3D"Open Sans,=
 sans-serif"><span style=3D"font-size:14.4px">=E2=80=9CThe new cluster is o=
nly permitted to have temporary logical slots, i.e., ones where pg_replicat=
ion_slots.temporary is true.=E2=80=9D</span></font></div><div><font face=3D=
"Open Sans, sans-serif"><span style=3D"font-size:14.4px"><br></span></font>=
</div><div><font face=3D"Open Sans, sans-serif"><span style=3D"font-size:14=
.4px">We could make it mirror the above one more closely, but as the former=
 mentions the old cluster and the later the new one, I kinda like the diffe=
rent flow, less likely to skim over it.</span></font></div><div><font face=
=3D"Open Sans, sans-serif"><span style=3D"font-size:14.4px"><br></span></fo=
nt></div><div><font face=3D"Open Sans, sans-serif"><span style=3D"font-size=
:14.4px">David J.</span></font></div><div><font face=3D"Open Sans, sans-ser=
if"><span style=3D"font-size:14.4px"><br></span></font></div>

--00000000000047b724064f8d596c--