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>
In-Reply-To: 
 <CAKFQuwaWUuXJYZSMKtiXFT=kFK-sFg+pSwK0MUN-MBEEobkfBg@mail.gmail.com>
From: Amit Kapila <amit.kapila16@gmail.com>
Date: Fri, 17 Apr 2026 09:24:47 +0530
Message-ID: 
 <CAA4eK1LWNPW7bTY+0=L183rCyqUmq6MuFkgTE8QwHeT6nkDmpg@mail.gmail.com>
Subject: Re: Logical Replication upgrade
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: "mimidatabase@gmail.com" <mimidatabase@gmail.com>,
	"pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: 
 <https://www.postgresql.org/message-id/CAA4eK1LWNPW7bTY%2B0%3DL183rCyqUmq6MuFkgTE8QwHeT6nkDmpg%40mail.gmail.com>
Precedence: bulk

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 b=
e no slots where pg_replication_slots.temporary is false.
>
> To be:
>
> =E2=80=9CThe new cluster is only permitted to have temporary logical slot=
s, 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."

--=20
With Regards,
Amit Kapila.