How do I turn on automatic minor version upgrades for my Aurora PostgreSQL-Compatible DB cluster?

Resolution

Turn on automatic minor version upgrades

Note: If you receive errors when you run AWS Command Line Interface (AWS CLI) commands, then see Troubleshooting errors for the AWS CLI. Also, make sure that you're using the most recent AWS CLI version.

The Auto minor version upgrade setting is turned on by default. If your DB cluster isn't automatically upgrading to the latest minor version, then use the Amazon Relational Database (Amazon RDS) console or the AWS CLI to turn it on. For more information, see Settings for Amazon Aurora.

Important: Amazon Aurora might automatically apply critical security updates or end-of-support upgrades regardless of the automatic minor version upgrade setting. Aurora Global Database doesn't support automatic minor version upgrades.

Use the RDS console

Complete the following steps:

1. Open the Amazon RDS console.
2. In the navigation pane, choose Databases.
3. Select the Aurora PostgreSQL-Compatible DB cluster that you want to modify.
4. Choose Modify.
5. In the Maintenance section, select Auto minor version upgrade.
6. Choose Continue.
7. In the Scheduling of modifications section, choose either Apply during the next scheduled maintenance window or Apply immediately.
8. Choose Modify cluster.

Use the AWS CLI

Note: In the following commands, replace CLUSTER-IDENTIFIER with your Aurora PostgreSQL-Compatible DB cluster ID.

To check whether auto minor version upgrade is turned on, run the following describe-db-clusters command:

aws rds describe-db-clusters \
  --db-cluster-identifier CLUSTER-IDENTIFIER \
  --query 'DBClusters[*].[DBClusterIdentifier,EngineVersion,AutoMinorVersionUpgrade]' \
  --output table

If auto minor version upgrade isn't turned on, then run the following modify-db-cluster command to turn it on:

aws rds modify-db-cluster \
  --db-cluster-identifier CLUSTER-IDENTIFIER \
  --auto-minor-version-upgrade \
  --apply-immediately

Modify the maintenance window

To change when automatic minor version upgrades occur, see Adjusting the preferred DB cluster maintenance window.

Note: The maintenance window must be at least 30 minutes long.

Related information

Automatic minor version upgrades for Aurora DB clusters

Upgrading Amazon Aurora PostgreSQL DB clusters

Performing a minor version upgrade