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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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






[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux