Level: Intermediate
Migrating a large fleet of PostgreSQL databases to a managed service is a journey filled with opportunities and potential pitfalls. This is especially true when dealing with numerous multi-terabyte databases and particular cases such as migrating from an old version, using inheritance, PostGIS, moving to GCP Service accounts, and changing database assignment to instances.
This session shares the real-world experience of migrating more than 100 PostgreSQL databases, ranging in size from gigabytes to multiple terabytes, from traditional virtual machines to a managed cloud service, specifically Google Cloud SQL for PostgreSQL.
We will share lessons learned, covering planning, execution, and problems encountered, with practical advice to save you time, resources, and headaches during a similar migration. Key discussion areas will include tooling selection, pre-migration assessments, choosing the right instance type, optimizing the migration process for large datasets, strategies for minimizing downtime, and essential post-migration validation and performance tuning.
This session is a must-attend for anyone considering or currently executing a large-scale PostgreSQL migration to a managed service and wants to learn from real-world successes and challenges.