Migrate Postgres to newer version

[mrnicegyu11]

We need to migrate our postgres database upwards, as our version is reaching end of lifetime

Message from aws:

Hello,
You are receiving this message because you have one or more Amazon RDS DB instances running with PostgreSQL major version 10 that requires your attention. Amazon RDS for PostgreSQL is announcing deprecation of its PostgreSQL major version 10, starting April 17, 2023. PostgreSQL community plans to deprecate PostgreSQL 10 on November 10, 2022 [1] and it will not receive any security patches after November 10, 2022. We strongly recommend that you monitor the PostgreSQL security page for documented vulnerabilities [2].
We recommend that you take action and upgrade your PostgreSQL databases running on major version 10 to a later major version, such as version 14. PostgreSQL 14 includes performance improvements for parallel queries, heavily-concurrent workloads, partitioned tables, logical replication, and vacuuming. To learn more about the benefits of PostgreSQL 14, please refer to ‘PostgreSQL 14 Community Release Announcement’ [3]
To upgrade your DB instance from major version 10, we recommend that you first upgrade your current version of database to a minor version such as 10.19 or later that has an upgrade path to the target major version, and then perform an upgrade to a later major version, such as 14. You can initiate an upgrade by going to the Modify DB Instance page in the AWS Management Console and change the database version setting to a newer major version of PostgreSQL. Alternatively, you can also use the AWS CLI to perform the upgrade. While major version upgrades typically complete within the standard maintenance window, the duration of the upgrade depends on the number of objects within the database. To avoid any unplanned unavailability outside your maintenance window, we recommend that you first take a snapshot of your database and test the upgrade to get an estimate of the upgrade duration. To learn more about upgrading PostgreSQL major versions in RDS, review the 'Upgrading Database Versions' page [4].
The upgrade process will shutdown the database instance, perform the upgrade, and restart the database instance. The DB instance may restart multiple times during the process. If you choose the "Apply Immediately" option, the upgrade will be initiated immediately after clicking on the "Modify DB Instance" button. If you choose not to apply the change immediately, the upgrade will be performed during your next maintenance window.
Your affected Amazon RDS DB Instances are listed in "Affected Resources" tab of the AWS Health Dashboard.

[sanderegg]

possible workflow for testing:

• import database from production/staging in local dev
• apply migration as in https://www.postgresql.org/docs/current/pgupgrade.html

final migration shall be devised later on

[sanderegg]

@mrnicegyu11 this can be closed after the release 1.39.0 right?

[mrnicegyu11]

@sanderegg , yes, this should be done and the issue can be closed as of today :)

[mrnicegyu11]

this is done