Announcement: Amazon Aurora PostgreSQL 10.x end of support is January 31, 2023

From January 31, 2023, Amazon Aurora PostgreSQL-compatible edition will no longer support major version 10.x. Per the Aurora Version Policy (1), we are providing 12 months notice to give you time to upgrade your database cluster(s). We recommend that you proactively upgrade your databases running Amazon Aurora PostgreSQL major version 10.x to Amazon Aurora PostgreSQL 11 or higher at your convenience before January 31, 2023.

If you do not upgrade your database running Aurora PostgreSQL 10.x before January 31, 2023, Amazon Aurora will upgrade your Amazon Aurora PostgreSQL 10.x databases to the appropriate Amazon Aurora PostgreSQL major version during a scheduled maintenance window on or after January 31, 2023.

How to Determine Which Instances are Running Aurora PostgreSQL 10.x In the Amazon RDS console, you can see details about a database cluster, including the Aurora PostgreSQL version of instances in the cluster, by choosing Databases from the console's navigation pane. To view DB cluster information by using the AWS CLI, use the describe-db-clusters command. To view DB cluster information using the Amazon RDS API, use the DescribeDBClusters operation. (2) You can also query a database directly to get the version number by querying the aurora_version() system function i.e., "SELECT * FROM aurora_version();".

*How to Upgrade to a New Major Version * You can initiate an upgrade of your database instance — either immediately or during your next maintenance window — to a newer major version of Amazon Aurora PostgreSQL using the AWS Management Console or the AWS Command Line Interface (CLI). The upgrade process will shut down the database instance, perform the upgrade, and restart the database instance. The database instance may be restarted multiple times during the upgrade process. 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 (3) or a fast database clone (4) of your database and test the upgrade to get an estimate of the duration. To learn more about upgrading PostgreSQL major versions in Aurora, review the Upgrading Database Versions page (5).

Please be aware of the following timeline: • Now through January 31, 2023 - You can initiate upgrades of Amazon Aurora PostgreSQL 10.x instances to Amazon Aurora PostgreSQL 11 or higher at any time. • Starting August 1, 2022, you will no longer be able to create new Aurora clusters or instances with Aurora PostgreSQL major version 10.x from either the AWS Console or the CLI. You can still add read replicas to existing Aurora PostgreSQL 10.x clusters and continue to apply changes to existing Aurora PostgreSQL 10.x instances, such as migrating to a Graviton2 R6g instance or changing instance configuration, until January 31, 2023. • Starting January 31, 2023 Amazon Aurora will upgrade your Amazon Aurora PostgreSQL 10.x databases to the appropriate Amazon Aurora PostgreSQL major version during a scheduled maintenance window on or after January 31, 2023. Restoration of Amazon Aurora PostgreSQL 10.x database snapshots will result in an automatic upgrade of the restored database to a supported version at the time.

[1]https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.VersionPolicy.html [2] https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/accessing-monitoring.html [3] https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_CreateSnapshotCluster.html [4] https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Managing.Clone.html [5] https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.Updates.html