Help improve AWS Support Official channel in re:Post and share your experience - complete a quick three-question survey to earn a re:Post badge!
[Action Required] Upgrade Amazon Aurora PostgreSQL 11.12, 12.7, and 13.3 minor versions by March 15, 2023
Newer versions of Amazon Aurora PostgreSQL-compatible edition are now available and database cluster(s) running Aurora PostgreSQL minor versions 11.12, 12.7, and 13.3 need to be upgraded by March 15, 2023. These newer minor versions include important updates that will improve the operations of your Aurora PostgreSQL instances and workloads. We strongly encourage you to upgrade to at least a recommended minimum minor version at your earliest convenience.
- For PostgreSQL Minor Version 11.12, the recommended minimum minor version is 11.17.
- For PostgreSQL Minor Version 12.7, the recommended minimum minor version is 12.12.
- For PostgreSQL Minor Version 13.3, the recommended minimum minor version is 13.8.
Starting on or after 12:00 PM PDT on March 15, 2023, if your Amazon Aurora PostgreSQL cluster has not been upgraded to a newer minor version, we will schedule the relevant recommended minimum minor version to be automatically applied during your next maintenance window. Changes will apply to your cluster during your next maintenance window even if auto minor version upgrade is disabled.
Restoration of Amazon Aurora PostgreSQL 11.12, 12.7, and 13.3 database snapshots after March 15, 2023 will result in an automatic upgrade of the restored database to a supported version at the time.
How to Determine Which Instances are Running These Minor Versions?
- 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. 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 Apply a New Minor Version You can apply a new minor version in the AWS Management Console, via the AWS CLI, or via the RDS API. Customers using CloudFormation are advised to apply updates in CloudFormation. We advise you to take a manual snapshot before upgrading. For detailed upgrade procedures, please see the available User Guide [1]. Please be aware that your cluster will experience a short period of downtime when the update is applied.
Visit the Aurora Version Policy [2] and the documentation [3] for more information and detailed release notes about minor versions, including existing supported versions.
If you have any questions or concerns, the AWS Support Team is available on AWS re:Post and via Premium Support [4].
[1] https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_UpgradeDBInstance.PostgreSQL.html [2] https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/Aurora.VersionPolicy.html [3] https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/AuroraPostgreSQL.Updates.20180305.html [4] https://aws.amazon.com/support
- Newest
- Most votes
- Most comments
It looks like you received a notification about the need to upgrade your Amazon Aurora PostgreSQL clusters running on versions 11.12, 12.7, and 13.3 by March 15, 2023. Since this is a critical update, here’s what you can do to address the action required:
Steps to Upgrade Amazon Aurora PostgreSQL: Check Current Aurora PostgreSQL Versions:
AWS Management Console: Go to the RDS section, navigate to Databases, and select your Aurora PostgreSQL clusters. Look under the "DB Version" field to identify the minor versions.
AWS CLI: Use the describe-db-clusters command to get the cluster version: aws rds describe-db-clusters --query 'DBClusters[*].{DBClusterIdentifier:DBClusterIdentifier,EngineVersion:EngineVersion}' Direct Database Query: You can also query the version directly from the PostgreSQL database: SELECT * FROM aurora_version(); Upgrade Aurora PostgreSQL Version:
Recommended Minimum Versions:
For 11.12, upgrade to 11.17 or higher. For 12.7, upgrade to 12.12 or higher. For 13.3, upgrade to 13.8 or higher.
You can perform the upgrade: In the AWS Management Console: Go to the RDS section. Select your cluster and click Modify. Choose the New DB Engine Version from the dropdown (make sure to select the recommended version). Apply the changes immediately or during the next maintenance window.
Using AWS CLI: Use the modify-db-cluster command to upgrade the version: aws rds modify-db-cluster --db-cluster-identifier <your-cluster-id> --engine-version <new-version> --apply-immediately Take a Snapshot Before Upgrading: Before proceeding with the upgrade, it's recommended to take a manual snapshot of your Aurora PostgreSQL cluster to ensure you can restore it if needed:
AWS Management Console: In the Databases section, select the cluster and click Actions > Take snapshot.
AWS CLI: aws rds create-db-cluster-snapshot --db-cluster-identifier <your-cluster-id> --db-cluster-snapshot-identifier <snapshot-name> Monitor Upgrade Process: Once the upgrade starts, monitor the process to check for any issues during the upgrade. The upgrade process may cause a brief period of downtime, but it should be minimal.
Post-Upgrade Actions:
Verify Version: After the upgrade completes, verify that the correct version has been applied.
Monitor Application: Ensure that your application continues to work as expected with the new version. Check for any compatibility issues or regressions.
regards, M Zubair https://zeonedge.com
