A New Hope for Database Migrations

Date: 2018-09-06
Time: 13:30 - 14:20
Room: Mission
Level: Intermediate

Version controlling your PostgreSQL database is basic hygiene, as essential as version controlling your code. Unlike code, PostgreSQL requires live upgrades — modifying your engine mid-flight — and is immeasureably more complex.

I've authored thousands of migrations across dozens of PostgreSQL databases using several different migration systems. This talk is for DBAs and developers, covers pitfalls of database migrations, and offers solutions that will save your data and your SLA.

I'll paint a path forward for better database versioning, including: Distributed workflows, like git. Adding and removing extensions. Loading large data files. Long-running & asynchronous data migrations. Orchestrating logical replication between databases. Making our tooling for authoring migrations as convenient as "doing it live".


Scott Milliken