Getting a list of available versions in your AWS Region - Amazon Aurora

Getting a list of available versions in your AWS Region

You can get a list of all engine versions available as upgrade targets for your Aurora PostgreSQL DB cluster by querying your AWS Region using the describe-db-engine-versions AWS CLI command, as follows.

For Linux, macOS, or Unix:

aws rds describe-db-engine-versions \
  --engine aurora-postgresql \
  --engine-version version-number \
  --query 'DBEngineVersions[*].ValidUpgradeTarget[*].{EngineVersion:EngineVersion}' \
  --output text

For Windows:

aws rds describe-db-engine-versions ^
  --engine aurora-postgresql ^
  --engine-version version-number ^
  --query "DBEngineVersions[*].ValidUpgradeTarget[*].{EngineVersion:EngineVersion}" ^
  --output text

For example, to identify the valid upgrade targets for an Aurora PostgreSQL version 12.10 DB cluster, run the following AWS CLI command:

For Linux, macOS, or Unix:

aws rds describe-db-engine-versions \
  --engine aurora-postgresql \
  --engine-version 12.10 \
  --query 'DBEngineVersions[*].ValidUpgradeTarget[*].{EngineVersion:EngineVersion}' \
  --output text

For Windows:

aws rds describe-db-engine-versions ^
  --engine aurora-postgresql ^
  --engine-version 12.10 ^
  --query "DBEngineVersions[*].ValidUpgradeTarget[*].{EngineVersion:EngineVersion}" ^
  --output text

In the following table, you can find both major and minor version upgrade targets for different Aurora PostgreSQL DB versions. To maintain compatibility, not all versions are offered as upgrade targets. Aurora PostgreSQL introduces new features and bug fixes with each quarterly minor version release. For information about Aurora PostgreSQL minor releases, see the Release Notes for Aurora PostgreSQL.

Current source version Upgrade targets
17.7

None
17.6

17.7
17.5

17.7, 17.6
17.4

17.7, 17.6, 17.5
16.11

None
16.10

17.7

16.11
16.9

17.7

16.11, 17.6, 16.10, 17.5
16.8

17.7

16.11, 17.6, 16.10, 17.5, 17.4, 16.9
16.6

17.7

16.11, 17.6, 16.10, 17.5, 17.4, 16.9, 16.8
16.4

17.7

16.11, 17.6, 16.10, 17.5, 17.4, 16.9, 16.8, 16.6
16.3

17.7

16.11, 17.6, 16.10, 17.5, 17.4, 16.9, 16.8, 16.6, 16.4
16.2

17.7

16.11, 17.6, 16.10, 17.5, 17.4, 16.9, 16.8, 16.6, 16.4, 16.3
16.1

17.7

16.11, 17.6, 16.10, 17.5, 17.4, 16.9, 16.8, 16.6, 16.4, 16.3, 16.2
15.15

None
15.14

17.7

16.11

15.15
15.13

17.7

16.11, 15.15, 17.6, 16.10, 15.14, 17.5, 16.9
15.12

17.7

16.11, 15.15, 17.6, 16.10, 15.14, 15.13
15.10

17.7

16.11, 15.15, 17.6, 16.10, 15.14, 17.5, 17.4, 16.9, 16.8, 15.13
15.11

17.7

16.11, 15.15, 17.6, 16.10, 15.14, 17.5, 17.4, 16.9, 16.8, 16.6, 15.13, 15.12
14.20

None

For any version that you're considering, always check the availability of your cluster's DB instance class. For example, db.r4 isn't supported for Aurora PostgreSQL 13. If your Aurora PostgreSQL DB cluster currently uses a db.r4 instance class, you need to modify it to use a supported DB instance class before you can upgrade to Aurora PostgreSQL 13. For more information about the available Aurora PostgreSQL DB instance classes, including which ones are Graviton2-based and which ones are Intel-based, see Amazon Aurora DB instance classes.