AWS automatic upgrade PostgreSQL version?

Question

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?

Answer

Hello,

Regarding Amazon RDS PostgreSQL version deprecation, I would recommend that you refer to [Urgent Action Required - Upgrade your RDS for PostgreSQL minor versions](https://repost.aws/questions/QUFNvjJvouStKctZ541a1nAA/urgent-action-required-upgrade-your-rds-for-postgre-sql-minor-versions) for more detailed information.

If the existing Amazon RDS PostgreSQL instances running on deprecated version have [automatic minor version upgrade](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.Upgrading.html#USER_UpgradeDBInstance.Upgrading.AutoMinorVersionUpgrades) 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](https://repost.aws/questions/QUFNvjJvouStKctZ541a1nAA/urgent-action-required-upgrade-your-rds-for-postgre-sql-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](https://docs.aws.amazon.com/awssupport/latest/user/case-management.html#creating-a-support-case).

AWS automatic upgrade PostgreSQL version?

Relevant questions

RDS PostgreSQL minor version upgrade wasn't performed

How could I find out when an RDS instance would go out of support?