Smooth Sailing: How We Tackled PostgreSQL Migration Challenges from CentOS to Ubuntu
Wednesday, October 23 at 11:10–12:00
With CentOS approaching its end of life, the migration of PostgreSQL servers to a more sustainable operating system has become a critical task. In this presentation, we will delve into the process of migrating all PostgreSQL servers from CentOS to Ubuntu as part of Azure Cosmos DB for PostgreSQL, focusing on the numerous challenges encountered and the strategies employed to overcome them.
Prior to the actual migration, extensive validations were conducted on several clones of each cluster, testing various scenarios to ensure a seamless transition. Minimizing downtime for customers was a top priority, along with optimizing PostgreSQL performance to achieve the best possible results during reindexing on Ubuntu.
This session will provide a brief overview of the migration preparation, explaining our validation approach, followed by an in-depth discussion of the specific problems faced during the migration process. Attendees will gain valuable insights into the practical solutions we implemented to address these challenges, ensuring a smooth transition for PostgreSQL instances from CentOS to Ubuntu on Azure Cosmos DB for PostgreSQL.
