How to upgrade PostgreSQL from 16 to 17 in Docker

Upgrading PostgreSQL from 16 to 17 in Docker without losing data: run both versions side by side in docker-compose, back up with pg_dump, restore into the new container, then switch the app over. Five concrete steps plus the gotchas to watch out for.

Oct 28, 2024