Logical Replication upgrade

David G. Johnston <david.g.johnston@gmail.com>

From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Amit Kapila <amit.kapila16@gmail.com>
Cc: "mimidatabase@gmail.com" <mimidatabase@gmail.com>, "pgsql-docs@lists.postgresql.org" <pgsql-docs@lists.postgresql.org>
Date: 2026-04-16T05:46:06Z
Lists: pgsql-docs
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.”

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.

Commits

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

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