Re:Why Does Everyone Run Ancient Postgres Versions?
by kortilla on Friday October 18, 2024 @04:20AM
(#41877368)
Not if software regressions are the main concern.
Re:Why Does Everyone Run Ancient Postgres Versions?
by ttfkam on Friday October 18, 2024 @11:06AM
(#41880107)
Upgrading from v11 to v16 is not materially different in Postgres from v14 to v16. Same tools. Same strategies.
Re:Why Does Everyone Run Ancient Postgres Versions?
by enraged_camel on Friday October 18, 2024 @11:24AM
(#41880280)
We are planning to upgrade from 11 to 17 soon. Even thinking about it is giving me ulcers. Our infra provider said we actually need to upgrade to 13 first, and then to 17. They did not provide a reason.
Re:Why Does Everyone Run Ancient Postgres Versions?
by Tostino on Friday October 18, 2024 @12:04PM
(#41880673)
I went through a postgres 10 > 16 upgrade recently. What made it easier was just doing a test run of the upgrade process.
Did a restore to a stage environment, worked on my upgrade scripts until I was happy (deployed to VMs with ansible, so manual work to write the upgradeprocessfor me), restored again and ran the upgrade process fresh, and then tested my application, backup scripts, restores, etc. Had everything working entirely smoothly multiple times before pulling the trigger in production.
No stress at all when we did it in prod.
Additionally, actions done frequently are less risky than actions done rarely, since you develop skills in performing that action as an organization - see high deployment frequency as a strategy of managing deployment risk.
This adds up to continuous upgrading being the least risky option in aggregate.