Need guidance on upgrading RDS Posgres version

0

Hi Team,

I have two RDS Postgres instances in Oregon and Ireland region Both RDS instances are on the engine version 9.6.12. We need to upgrade this version to Postgres engine version 13.3. We tired multiple ways to upgrade the database version upgrading first to minor version 9.6.22 to upgrading to major version 9.6.12. However, when preforming the minor version upgrade, it does not show the list of version available to upgrade in the versions and when trying to upgrade to another minor version, the parameter group for the RDS instance is grayed out. Therefore this is a blocker for us to upgrade the database.Enter image description here

The screenshot of the error is attached. Appreciate your guidance.

Zaharan
gefragt vor einem Jahr224 Aufrufe
2 Antworten
0

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

AWS
beantwortet vor einem Jahr
0

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 :)

profile pictureAWS
SUPPORT-TECHNIKER
Brandon
beantwortet vor einem Jahr

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen