News Score: Score the News, Sort the News, Rewrite the Headlines

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

© News Score  score the news, sort the news, rewrite the headlines