
MTAR T3D Sessions: Why PostgreSQL Still Needs In-Place Major Version Upgrades
PostgreSQL major version upgrades still require more moving parts than many database teams would expect. In this Postgres Wishlist episode, James and JD examine why upgrading in place remains difficult, how pg_upgrade depends on binaries from the previous version, and why the process becomes increasingly awkward across modern deployment environments. Could PostgreSQL eventually support a major version upgrade with little more than a restart? James considers cross-version streaming replication as another possible path, while JD explores a hybrid approach that would replicate system objects logically and user data in binary form. From pg_upgrade and logical replication to RDS, disk formats, rollback, and operational downtime, the conversation examines what prevents PostgreSQL from offering a simpler upgrade path and what a more practical architecture could look like.


