Upgrading Postgres in Docker to Version 19: Breaking Changes to Watch For
PostgreSQL 19 was released on November 19, and a developer moved a small Docker-based tool to it, testing against official images for versions 17, 18 and 19. The biggest hurdle is a changed data directory layout introduced in version 18: the 19 image expects the volume mounted at /var/lib/postgresql rather than /var/lib/postgresql/data, and existing volumes need a dump/restore or pg_upgrade. The io_workers setting, used for async I/O tuning in version 18, was removed in 19 and replaced by io_min_workers, io_max_workers and related options, and an unrecognized parameter causes a fatal startup error. The author notes this can cause restart loops or failed upgrades if the old setting remains in configuration. They suggest using postgres -C as a lightweight way to validate configuration before starting a server.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.
Discussion (0)
Log in to join the discussion and vote.
Log in