Postgres Aurora DB major version upgrade with minimal downtime

1 · Lyft · March 11, 2024, 8:34 p.m.
Summary
Photo by Frank Olsen UNDER CC BY-SA 3.0 DEEDIntroductionOur payment platform team had the unique challenge to upgrade our Aurora Postgres DB from v10 to v13. This DB was responsible for storing transactions within Lyft and contains ~400 tables (with partitions) and ~30TB of data. Upgrading the database in-place would have resulted in ~30 mins of downtime. Such significant downtime is untenable — it would cause cascading failures across multiple downstream services, requiring a large amount of en...