By using AWS re:Post, you agree to the Terms of Use

AWS automatic upgrade PostgreSQL version?


Hi, today is 05/02/2022 this document : 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?

1 Answer


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.

answered 5 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions