Horton

Re: Logical Replication upgrade

vignesh C <vignesh21@gmail.com>

View thread View on postgr.es
From: vignesh C <vignesh21@gmail.com>
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>
Date: 2026-04-16T07:09:09Z
Lists: pgsql-docs

Attachments

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’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.”

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

Regards,
Vignesh

Commits

  1. Doc: Improve the wording of logical slot prerequisites.

  2. Doc: Add the steps for upgrading the logical replication cluster.