AWS automatic upgrade PostgreSQL version?
Hi, today is 05/02/2022 this document : https://aws.amazon.com/rds/faqs/?nc1=h_ls says:
Q: What happens when an Amazon RDS DB engine version is deprecated? When a minor version of a database engine is deprecated in Amazon RDS, we will provide a three (3) month period after the announcement before beginning automatic upgrades. At the end of this period, all instances still running the deprecated minor version will be scheduled for automatic upgrade to the latest supported minor version during their scheduled maintenance windows.
We are using PostgreSQL 10.14 (deprecated). run upon some db.m5.2xlarge and db.t2.micro instances.
Does the above statement mean AWS have a process in place to automatic upgrade our PostgreSQL from 10.14 to 10.17 without human interaction? I just ran a select version() and the output still says 10/14 :
PostgreSQL 10.14 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.3 20140911 (Red Hat 4.8.3-9), 64-bit
Will AWS upgrade from deprecated minor version to highest non-deprecated minor it could find (which is 10/20) or the lowest non-deprecated minor version (which is 10.17)?
When was the exact announced date for 10.14 deprecation? Is there any web page to show exact deprecated date for all deprecation version? Or how could I find such information?
Regarding Amazon RDS PostgreSQL version deprecation, I would recommend that you refer to Urgent Action Required - Upgrade your RDS for PostgreSQL minor versions for more detailed information.
If the existing Amazon RDS PostgreSQL instances running on deprecated version have automatic minor version upgrade enabled, the instances will be automatically upgraded.
For deprecated version in Amazon RDS PostgreSQL version 10, instances will be automatically be upgraded to the version marked as "preferred" by RDS. The supported minor version supported will be from 10.17 and later. Urgent Action Required - Upgrade your RDS for PostgreSQL minor versions provides information on the preferred upgrade path.
If additional information is required to understand the upgrade process, I'd recommend creating a support case.
Upgrade for Amazon Aurora Serverless v1 PostgreSQL-compatible edition 10.x end of support is January 31, 2023asked a month ago
[Urgent Action Required] - Upgrade your RDS for PostgreSQL minor versionsasked 22 days ago
How could I find out when an RDS instance would go out of support?Accepted Answerasked 2 years ago
AWS automatic upgrade PostgreSQL version?asked a month ago
Cannot upgrade minor version RDS Aurora MySQL ClustersAccepted Answerasked 4 months ago
Cannot Upgrade DB engine due to performace insightAccepted Answerasked a year ago
How do I find out when a minor version upgrade occurred in an RDS?Accepted Answerasked 2 months ago
RDS PostgreSQL minor version upgrade wasn't performedasked 3 years ago
An unknown error on snapshot upgrade for PostgreSQLasked a month ago
Major Version Upgrade Aurora PostgreSQL 11asked 2 years ago