Need guidance on upgrading RDS Posgres version

You will not be able to do a minor version upgrade to 9.6.22 as Aurora version 9 is at end of support as shown here: https://docs.aws.amazon.com/AmazonRDS/latest/AuroraPostgreSQLReleaseNotes/AuroraPostgreSQL.Updates.html "Amazon Aurora PostgreSQL 1.X (compatible with PostgreSQL 9.6.XX) reached end of support on January 31, 2022." You should be able to do a major version upgrade to PostgreSQL 11 or higher https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_UpgradeDBInstance.PostgreSQL.html

Hey Zaharan,

There's a few points here but should be fairly easy to resolve:

1. The reason you can't upgrade to 9.6.22 is because it is deprecated. So you'll need to upgrade to at least 11.9 if you are on Aurora, which from the error message it looks like you are. If you want to upgrade to version 13 the earliest version available is 13.4. You can confirm this by running this command: aws rds describe-db-engine-versions
   --engine aurora-postgresql
   --engine-version 9.6.12 \
   --query 'DBEngineVersions[].ValidUpgradeTarget[?IsMajorVersionUpgrade == true].{EngineVersion:EngineVersion}'
   --output text

2. To upgrade you'll need to do this via the CLI instead of the Console. Follow this guide to ensure all requirements are met - https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_UpgradeDBInstance.PostgreSQL.html#USER_UpgradeDBInstance.PostgreSQL.MajorVersion

The command to upgrade is seen when you expand the AWS CLI toggle as seen below: aws rds modify-db-cluster
--db-cluster-identifier mydbcluster
--engine-version new_version
--allow-major-version-upgrade
--no-apply-immediately

Hope that helps :)