4 ms·
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,
by Tostino 2y ago
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.
- ttfkam 2y agoYep, that was our strategy as well: just keep iterating until the script run cleanly from start to finish without errors.