Postgres major version upgrades with minimal downtime
One of the challenges of running a Postgres database is upgrading to a new major version. Major version
upgrades can introduce new features, performance improvements, and bug fixes, but they can also be complex
and time-consuming.
The most accepted methods for upgrading Postgres to a new major are:
pg_upgrade for in-place upgrade, which involves stopping the server while
the upgrade is being performed. Even if this usually happens very fast, it means taking the service down for a few minutes, pl...
Read more at xata.io