Date: 2022-09-22
Time: 11:25–12:15
Room: The Library
Level: Intermediate
Feedback: Leave feedback
Getting under the covers: Migrating to PostgreSQL creatively and effectively Experience supporting many customer databases using various flavors of PostgreSQL (including AWS RDS, Amazon Aurora, GCP CloudSQL, and on-premises open-source PostgreSQL) that were migrated to from other database engines has taught us that technical challenges are best solved when your approach is tailored to the unique problem at hand.
In this session, we highlight three cases where the technical approach and code were designed to address specific challenges. We will discuss aspects of the code to demonstrate why these solutions were successful.
The examples we will showcase include:
Migrating large databases from on-prem PostgreSQL 11 into AWS RDS and Aurora PostgreSQL 13.
Moving from MySQL to Heroku: Here, we were tasked with moving small databases (few GBs), with a business requirement to move data and table contents incrementally. This required more creative migration techniques.