How to check AWS RDS PostgreSQL Minor Version Automatic Update Destination Version

Question

I received a notice from AWS that some minor versions of Postgres RDS will be forcibly updated.
This is causing disruption and hitting the real service. Because it uses multiple RDSs of different versions, you need to check which RDSs you only need to update in advance.
Is it okay to proceed with the update only for the minor versions exactly specified in the mail?
Or is there a place where I can check the minor versions that are currently subject to automatic updates?

re:Post Agent · Answer

To check the AWS RDS PostgreSQL Minor Version Automatic Update Destination Version, you can use the AWS Command Line Interface (CLI). This will help you determine which RDS instances need to be updated and plan accordingly.

You can use the following AWS CLI command to check the current automatic minor upgrade target version for a specific PostgreSQL minor version in a particular AWS Region:

```
aws rds describe-db-engine-versions \
--engine postgres \
--engine-version  \
--region  \
--query "DBEngineVersions[*].ValidUpgradeTarget[*].{AutoUpgrade:AutoUpgrade,EngineVersion:EngineVersion}" \
--output text
```

Replace  with the PostgreSQL version you're currently using, and  with your specific AWS Region.

This command will return information about the available upgrade targets, including whether they are set for automatic upgrade and their version numbers.

Additionally, you can check the status of the "Enable auto minor version upgrade" option for all your PostgreSQL DB instances using this command:

```
aws rds describe-db-instances \
--query '*[].{DBInstanceIdentifier:DBInstanceIdentifier,EngineVersion:EngineVersion,AutoMinorVersionUpgrade:AutoMinorVersionUpgrade}'
```

This will give you a list of all your DB instances, their current engine versions, and whether automatic minor version upgrades are enabled for each.

Regarding your question about proceeding with updates only for the minor versions specified in the email: While it's generally safe to follow AWS's recommendations, it's always a good practice to check the current automatic upgrade target versions using the commands provided above. This will give you the most up-to-date information and allow you to plan your upgrades more effectively.

Remember that automatic minor version upgrades are typically applied during your scheduled maintenance window if the "Enable auto minor version upgrade" option is enabled for your DB instance. If you want more control over the upgrade process, you can disable this option and perform the upgrades manually at a time that minimizes disruption to your services.

Before performing any upgrades, it's recommended to test the upgrade process in a non-production environment first to identify and address any potential issues specific to your database and workload.  
**Sources**  
[Automatic minor version upgrades for RDS for PostgreSQL - Amazon Relational Database Service](https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_UpgradeDBInstance.PostgreSQL.Minor.html)  
[Performing a minor version upgrade - Amazon Aurora](https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_UpgradeDBInstance.PostgreSQL.MinorUpgrade.html)  
[A lot of postgres versions suddenly deprecated | AWS re:Post](https://repost.aws/questions/QUX8YgP5yCT-GuhoBJAsWj8w/a-lot-of-postgres-versions-suddenly-deprecated)

How to check AWS RDS PostgreSQL Minor Version Automatic Update Destination Version

Add your answer

Relevant content