hapostgres
Upgrade primary and standby via pg_autoctl
It would be useful if pg_autoctl had a command to upgrade the primary and standby to a new version of Postgres via pg_upgrade without triggering a failover.
hope this feather will be able to use soon ! by now , is there any recommened steps to upgrade postgresql version in both primary / standby node ? I try pg_upgradecluster , but that command create a new postgresql instance at different port , not managed by pg_auto_failover. should I mark standy node to maintance , remove old version packages, install new packages , then come back to the cluster ? or remove the standby node , create a new version instance , join to the cluster as standby , then switch standy node to primary , then upgrade the standby node (the original primary ) ?
Hi @changchichung ; I think we're going to explore how to best solve major upgrades with pg_upgradecluster at a later point in time. Another candidate for automating upgrades uses logical replication, which requires a third node at least during the upgrade. We don't have a recommended major upgrade process at this time.
