Upgrade Postgresql version to 16 #734
Description
Describe the problem
Our Postgresql environments currently run on version 12, which has end-of-life in November 2024. Therefore, we should upgrade to the newest version, 16.
More info: https://www.postgresql.org/support/versioning
Proposed solution
We should do incremental upgrades from 12 to 16 iteratively on each environment(Qa and Prod).
Tasks:
- Upgrade DB to version 13 on Qa and test API+ Python functions
- Deploy to PROD version 13 upgrade
- Upgrade DB to version 14 on Qa and test API+ Python functions
- Deploy to PROD version 14 upgrade
- Upgrade DB to version 15 on Qa and test API+ Python functions
- Deploy to PROD version 15 upgrade
- Upgrade DB to version 16 Qa and test API+ Python functions
- Deploy to PROD version 16 upgrade
Alternatives you've considered
We can skip some versions. For example, jump from 12 to 14 and 14 to 16. The downside is we might hit blockers, especially geometric manipulation libraries. The safer approach is one by one.
Additional context
Each upgrade can be a separate issue as we need a prod release. The "urgent" upgrade is 13, as 12 is due in November this year as per Postgresql documentation, https://www.postgresql.org/support/versioning/