Workshop: Zero-Downtime Postgres Migrations

Workshop Starts in 2 months

Workshop: Zero-Downtime Postgres Migrations

Hands-on expand-and-contract migrations, backfills and safe rollbacks on a real dataset. Thirty seats, bring a laptop with Docker.

  • Tuesday 12 January 2027
  • Werkraum Mitte
  • 4 sessions
22 going

Overview

Hands-on with expand-and-contract migrations, backfills and safe rollbacks on a real dataset. Bring a laptop with Docker installed; we send the container image the week before so the first half-hour is not spent on hotel Wi-Fi.

Ruth Achterberg leads four tight blocks in a bright second-floor room on Linienstraße, with two assistants walking the tables. You will rename a busy column without a lock, backfill forty million rows in batches, and then deliberately break a deploy so you can practise the rollback while the clock is running.

Thirty seats at long shared tables, power at every place, coffee and pretzels at the break. You leave with the scripts, a checklist you can paste into your own runbook and a certificate of attendance for your manager.

Schedule

4 sessions

Tuesday 12 January

  1. 13:00 13:30

    Setup check and dataset tour

    Ruth Achterberg Werkraum Mitte, room 2

  2. 13:30 14:45

    Expand and contract, step by step

    Ruth Achterberg Werkraum Mitte, room 2

  3. 15:00 16:00

    Backfills that do not lock the table

    Ruth Achterberg Werkraum Mitte, room 2

  4. 16:00 17:00

    Rollback drill and Q&A

    Ruth Achterberg Werkraum Mitte, room 2

Log in to build your own agenda and keep session notes.

Venue & travel

Werkraum Mitte

Werkraum Mitte, Linienstraße, Mitte, Berlin, Germany