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?
Hello,
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.
Relevant questions
Upgrade for Amazon Aurora Serverless v1 PostgreSQL-compatible edition 10.x end of support is January 31, 2023
asked a month ago[Urgent Action Required] - Upgrade your RDS for PostgreSQL minor versions
asked 22 days agoHow could I find out when an RDS instance would go out of support?
Accepted Answerasked 2 years agoAWS automatic upgrade PostgreSQL version?
asked a month agoCannot upgrade minor version RDS Aurora MySQL Clusters
Accepted Answerasked 4 months agoCannot Upgrade DB engine due to performace insight
Accepted Answerasked a year agoHow do I find out when a minor version upgrade occurred in an RDS?
Accepted Answerasked 2 months agoRDS PostgreSQL minor version upgrade wasn't performed
asked 3 years agoAn unknown error on snapshot upgrade for PostgreSQL
asked a month agoMajor Version Upgrade Aurora PostgreSQL 11
asked 2 years ago