Dear PostgreSQL Support Team,
I am planning to upgrade both nodes of our PostgreSQL 11 cluster simultaneously and would like your review of our proposed approach:
Current Setup:
Two PostgreSQL 11 nodes managed by Patroni
Planning for full outage during upgrade but I need to upgrade two node not replicate data from primary after upgrade because I have two site and if I use replication for 1.8 TB that will take 1 month
Proposed Upgrade Approach:
Pre-upgrade Steps:
Take full backup using pg_dumpall
Stop all application connections
Stop Patroni on both nodes
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
Post-upgrade Steps:
Start Patroni on intended primary node first
Start Patroni on secondary node
Verify cluster health
Please review this approach and advise:
Are there any critical risks in upgrading both nodes simultaneously?
What additional precautions should we take?
What specific problems might we encounter with Patroni after such an upgrade?
Your guidance would be greatly appreciated.
Best regards,
