What key factors must one consider while upgrading a Postgres to a significant version on AWS, e.g., from version 10 to version 13?
For upgrading Postgres on AWS EC2 machines, the steps would be the same as that of on-premises Postgres deployment.
- Check the release note of the latest version for any incompatibilities.
- Take the backup of the Postgres database that you plan to upgrade.
- Test upgrade in UAT environment and test the application against the latest upgraded version of Postgres for function and performance evaluation
- Perform the upgrade in the production environment and identify the cut-off time for the application.