Upgrading and Testing Rollback

Upgrading large, multi-TB databases to higher versions require a lot of planning and testing.

In this PGConf NYC 2023 presentation, Shailesh Rangani, Director and Global Practice Lead of PostgreSQL Services, Datavail, discussed the challenges of upgrading large, multi-TB databases to newer versions. Rangani shared a step-by-step process for implementing a blue-green deployment approach using Amazon Aurora PostgreSQL-Compatible Edition capabilities. Throughout this session, he also covered Amazon Aurora’s rapid database cloning feature, best practices, and lessons learned from real-world scenarios.

Fill out the form on this page to download the slides and learn about:

• Methods to perform Amazon Aurora PostgreSQL upgrades.
• Amazon Aurora fast database cloning.
• The process of upgrading a multi-TB database with near-zero downtime.
• Best practices and lessons learned from real-world large-scale PostgreSQL upgrades.
• Amazon Aurora Blue/Green deployment use cases.

About the Speaker

Shailesh Rangani is the Global Practice Lead of PostgreSQL at Datavail, with over 18 years of experience in the database domain. He holds certifications on cloud platforms including AWS, Azure, and OCI, along with database platforms like Oracle, PostgreSQL, MongoDB, and Db2 LUW. Rangani is an expert in designing, deploying, administering, and managing data-intensive applications that enable organizations to effectively analyze and process large volumes of structured and unstructured data.