Re: Advice Needed: Simultaneous Upgrade of Two-Node PostgreSQL 11 Cluster

On Sun, 2025-01-05 at 19:57 +0200, kasem adel wrote:
> Proposed Upgrade Approach:
> 
> Simultaneous Upgrade Process:
> 
> Install new PostgreSQL version packages on both nodes
> Run pg_upgrade with --check flag on both nodes
> Execute pg_upgrade with --link option on both nodes simultaneously
> Update Patroni configuration for new version on both nodes

No, that won't work.

You have to upgrade the primary, then rebuild the standby with
"patronictl reinit".  There is no safe way to upgrade the standby.

Yours,
Laurenz Albe