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: vignesh C <vignesh21@gmail.com>
Date: Thu, 16 Apr 2026 12:39:09 +0530
Message-ID: 
 <CALDaNm2_XoL7hsn6CMDC6hCpcOaLCKk_n8y1WnKS_-uJYLGwtQ@mail.gmail.com>
Subject: Re: Logical Replication upgrade
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: Amit Kapila <amit.kapila16@gmail.com>,
	"mimidatabase@gmail.com" <mimidatabase@gmail.com>,
	"pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Content-Type: multipart/mixed; boundary="000000000000f0b8ea064f8e82fa"
Archived-At: 
 <https://www.postgresql.org/message-id/CALDaNm2_XoL7hsn6CMDC6hCpcOaLCKk_n8y1WnKS_-uJYLGwtQ%40mail.gmail.com>
Precedence: bulk

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

On Thu, 16 Apr 2026 at 11:16, 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

+1 for this, the attached patch has the changes for the same.

Regards,
Vignesh

--000000000000f0b8ea064f8e82fa
Content-Type: application/octet-stream;
	name="0001-Improve-slot-prerequisite-wording-for-logical-replic.patch"
Content-Disposition: attachment;
	filename="0001-Improve-slot-prerequisite-wording-for-logical-replic.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_mo150weo0>
X-Attachment-Id: f_mo150weo0

RnJvbSA4YWIxZGM3NjhkNzRmMjY0YjhmNWNkMDI1ZmNiMGNlODRjZWQyZTY5IE1vbiBTZXAgMTcg
MDA6MDA6MDAgMjAwMQpGcm9tOiBWaWduZXNoIEMgPHZpZ25lc2gyMUBnbWFpbC5jb20+CkRhdGU6
IFRodSwgMTYgQXByIDIwMjYgMTI6MzY6MzQgKzA1MzAKU3ViamVjdDogW1BBVENIXSBJbXByb3Zl
IHNsb3QgcHJlcmVxdWlzaXRlIHdvcmRpbmcgZm9yIGxvZ2ljYWwgcmVwbGljYXRpb24KIHVwZ3Jh
ZGUKClJlcGhyYXNlIHRoZSBsb2dpY2FsIHNsb3QgcHJlcmVxdWlzaXRlIGNoZWNrcyBpbiB0aGUg
dXBncmFkZQpkb2N1bWVudGF0aW9uIHRvIG1ha2UgdGhlIGNvbmRpdGlvbnMgZWFzaWVyIHRvIHJl
YWQuCgpUaGUgcHJldmlvdXMgd29yZGluZyB1c2VkIG5lZ2F0aXZlIGNvbnN0cnVjdGlvbnMgc3Vj
aCBhcyAidGhlcmUgYXJlIG5vCnNsb3RzIHdob3NlIC4uLiBpcyBub3QgdHJ1ZSIgYW5kICJtdXN0
IG5vdCBoYXZlIHBlcm1hbmVudCBsb2dpY2FsCnNsb3RzIiwgd2hpY2ggbWFkZSB0aGUgcmVxdWly
ZW1lbnRzIGhhcmRlciB0byBwYXJzZSBxdWlja2x5LgoKUmV3cml0ZSB0aGVzZSBjaGVja3MgdXNp
bmcgZGlyZWN0IHBvc2l0aXZlIHBocmFzaW5nOgphbGwgc2xvdHMgb24gdGhlIG9sZCBjbHVzdGVy
IG11c3QgaGF2ZSBjb25mbGljdGluZyA9IGZhbHNlLCBhbmQgdGhlCm5ldyBjbHVzdGVyIG1heSBv
bmx5IGNvbnRhaW4gdGVtcG9yYXJ5IGxvZ2ljYWwgc2xvdHMgd2hlcmUgdGVtcG9yYXJ5ID0KdHJ1
ZS4KClRoaXMgaW1wcm92ZXMgcmVhZGFiaWxpdHkgd2hpbGUga2VlcGluZyB0aGUgbWVhbmluZyB1
bmNoYW5nZWQuCi0tLQogZG9jL3NyYy9zZ21sL2xvZ2ljYWwtcmVwbGljYXRpb24uc2dtbCB8IDEx
ICsrKysrLS0tLS0tCiAxIGZpbGUgY2hhbmdlZCwgNSBpbnNlcnRpb25zKCspLCA2IGRlbGV0aW9u
cygtKQoKZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9sb2dpY2FsLXJlcGxpY2F0aW9uLnNnbWwg
Yi9kb2Mvc3JjL3NnbWwvbG9naWNhbC1yZXBsaWNhdGlvbi5zZ21sCmluZGV4IDIzYjI2ODI3M2I5
Li5iMTEyY2ZkZTdlNyAxMDA2NDQKLS0tIGEvZG9jL3NyYy9zZ21sL2xvZ2ljYWwtcmVwbGljYXRp
b24uc2dtbAorKysgYi9kb2Mvc3JjL3NnbWwvbG9naWNhbC1yZXBsaWNhdGlvbi5zZ21sCkBAIC0y
Nzg1LDE4ICsyNzg1LDE3IEBAIENPTlRFWFQ6ICBwcm9jZXNzaW5nIHJlbW90ZSBkYXRhIGZvciBy
ZXBsaWNhdGlvbiBvcmlnaW4gInBnXzE2Mzk1IiBkdXJpbmcgIklOU0VSCiAgICAgPC9saXN0aXRl
bT4KICAgICA8bGlzdGl0ZW0+CiAgICAgIDxwYXJhPgotICAgICAgQWxsIHNsb3RzIG9uIHRoZSBv
bGQgY2x1c3RlciBtdXN0IGJlIHVzYWJsZSwgaS5lLiwgdGhlcmUgYXJlIG5vIHNsb3RzCi0gICAg
ICB3aG9zZQorICAgICAgQWxsIHNsb3RzIG9uIHRoZSBvbGQgY2x1c3RlciBtdXN0IGJlIHVzYWJs
ZSwgaS5lLiwgdGhlaXIKICAgICAgIDxsaW5rIGxpbmtlbmQ9InZpZXctcGctcmVwbGljYXRpb24t
c2xvdHMiPnBnX3JlcGxpY2F0aW9uX3Nsb3RzPC9saW5rPi48c3RydWN0ZmllbGQ+Y29uZmxpY3Rp
bmc8L3N0cnVjdGZpZWxkPgotICAgICAgaXMgbm90IDxsaXRlcmFsPnRydWU8L2xpdGVyYWw+Lgor
ICAgICAgaXMgPGxpdGVyYWw+ZmFsc2U8L2xpdGVyYWw+LgogICAgICA8L3BhcmE+CiAgICAgPC9s
aXN0aXRlbT4KICAgICA8bGlzdGl0ZW0+CiAgICAgIDxwYXJhPgotICAgICAgVGhlIG5ldyBjbHVz
dGVyIG11c3Qgbm90IGhhdmUgcGVybWFuZW50IGxvZ2ljYWwgc2xvdHMsIGkuZS4sCi0gICAgICB0
aGVyZSBtdXN0IGJlIG5vIHNsb3RzIHdoZXJlCisgICAgICBUaGUgbmV3IGNsdXN0ZXIgaXMgb25s
eSBwZXJtaXR0ZWQgdG8gaGF2ZSB0ZW1wb3JhcnkgbG9naWNhbCBzbG90cywgaS5lLiwKKyAgICAg
IG9uZXMgd2hlcmUKICAgICAgIDxsaW5rIGxpbmtlbmQ9InZpZXctcGctcmVwbGljYXRpb24tc2xv
dHMiPnBnX3JlcGxpY2F0aW9uX3Nsb3RzPC9saW5rPi48c3RydWN0ZmllbGQ+dGVtcG9yYXJ5PC9z
dHJ1Y3RmaWVsZD4KLSAgICAgIGlzIDxsaXRlcmFsPmZhbHNlPC9saXRlcmFsPi4KKyAgICAgIGlz
IDxsaXRlcmFsPnRydWU8L2xpdGVyYWw+LgogICAgICA8L3BhcmE+CiAgICAgPC9saXN0aXRlbT4K
ICAgIDwvaXRlbWl6ZWRsaXN0PgotLSAKMi40My4wCgo=
--000000000000f0b8ea064f8e82fa--