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 *Details :* Current version of PostgreSQL is *14.6 * OS: Linux HA :Pacemaker Based Master -Slave --Setup If anyone has experience performing a similar upgrade or can point me to relevant documentation or case studies, that would be extremely helpful. Thank you in advance for your support. -- Regards & Thanks, Jaya Sandeep Mobile: +91 94927 27845
