Guidance Required for PostgreSQL Major Version Upgrade in Pacemaker HA Cluster - Mailing list pgsql-general

Dear PostgreSQL Community,

I am currently planning a major upgrade of our PostgreSQL environment to the latest stable version and would appreciate your guidance on the best approach.

Our current setup consists of a high-availability cluster managed by Pacemaker on a Linux operating system, configured in a master–slave (primary–standby) architecture. Given the critical nature of this environment, we want to ensure the upgrade is performed with minimal downtime and without compromising data integrity or cluster stability.

I would be grateful if the community could share insights or best practices on the following:

• Recommended upgrade strategy (in-place upgrade vs. logical replication vs. dump/restore) for a Pacemaker-managed HA cluster

• Handling failover and cluster resources during the upgrade process

• Any precautions or common pitfalls specific to Pacemaker-based PostgreSQL clusters

• Suggested sequence of steps to ensure a smooth and safe transition

Thank you in advance for your support.

--