- 新しい順
- 投票が多い順
- コメントが多い順
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:
-
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 -
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 :)
関連するコンテンツ
- 質問済み 6年前
- AWS公式更新しました 3年前