3 ms·
> You can't upgrade in place. The Postgres documentation (which is generally excellent) describes workflows for upgrading across major releases, including what
by zozbot234 5y ago
> You can't upgrade in place.
The Postgres documentation (which is generally excellent) describes workflows for upgrading across major releases, including what can be fairly described as an "in-place" upgrade, via pg_upgrade and the "--link" option.
Upgrades without downtime can be achieved by using logical replication to create a standby instance running the new major release, then switching the new instance to primary.
- hn_throwaway_99 5y agoYeah, was just about to post this about pg_upgrade. In addition, there was a front page post on HN recently about Adyen upgrading their 50 terabyte postgres instance with minimal downtime: https://news.ycombinator.com/item?id=29923303 https://news.ycombinator.com/item?id=29923303