~/talk

PostgreSQL Major Upgrades: Swapping the Elephant Without Breaking the Room

on YouTube 32m
Talkat ContainerDays Hamburg 2026 · 2026-09-02..09-04· [databases]

speaker

name:Anton Borisov
links:none on file

resources

video:https://youtu.be/3BpB88X4bCE
slides:none on file

summary

Built an automated blue-green upgrade framework that moves ~100 production Postgres instances from 12 to 17 with logical decoding, controlled WAL overlap and connector orchestration; Debezium connectors, replication origins, and PgBouncer pools coordinate to keep CDC and outbox topics continuous with dry‑run and rollback modes. Cutover script (initially bash) achieves the visible switch in ~3 seconds, but EBS lazy‑load prewarming can take 7–12 hours and large monoliths produced up to ~2,000 transient errors during validation.

AI-written summary · about

chapters (11)

  1. 0:00Introduction and context
  2. 1:10Speaker introduction and talk overview
  3. 3:37Blue-green upgrade approach explained
  4. 8:10CDC and outbox patterns with DBZ
  5. 12:27Switch-over process and tools
  6. 16:20Critical gotchas during upgrade
  7. 20:11Final architecture and orchestration
  8. 22:39Extending the framework and optimizations
  9. 24:48Elixir-specific challenges
  10. 25:51Key takeaways and recommendations
  11. 26:33Q&A and resources

related talks

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.