No In-Place Major Version Upgrades

PostgreSQL does not support in-place major version upgrades. Upgrades require either dumping and restoring the entire dataset or setting up logical replication, with rigorous application compatibility testing required. Delaying upgrades increases complexity and risk, as outdated versions miss critical security patches, transforming routine maintenance into a complex, high-risk migration project.

Sources

• https://wippler.dev/posts/postgresql-is-terrible
• https://news.ycombinator.com/item?id=43886414
• https://experience.percona.com/postgresql/postgresql-complexity-and-your-business/enterprise-scale-challenges-real-world-postgresql-issues-youll-face
• https://www.siriusopensource.com/en-us/blog/postgres-problems-what-are-challenges-using-postgresql-enterprise

Collection History