0

I have a Postgres database in AWS RDS currently running version 9.6.11, and I'm trying to perform a major upgrade to version 10.7. I've followed the Upgrade Guide to create a new version-compatible parameter group, and also created a new version-compatible option group just in case.

When I attempt to initiate the upgrade in the AWS Console, I get this error message.

Current Option Group (integration-postgres96) is non-default. You need to explicitly specify a new Option Group in this case (default or custom) (Service: AmazonRDS; Status Code: 400; Error Code: InvalidParameterCombination;

However, there is no apparent place in the RDS console that allows me to specify a new Option Group. What am I missing? Is there something else that needs to be done so that I can upgrade through the Console, or am I required to use the CLI or REST API to accomplish this?

1

Databases can only be upgraded in the RDS Console if they use a default option group. (Presumably all databases created in the RDS Console also use the default option group.)

In my case, the database was created with a tool that invokes the RDS API. In order to upgrade my database, I needed to use either the RDS API or the AWS CLI as described on the Manual Upgrade page. The upgrade command looked like this:

$ aws rds modify-db-instance \
  --db-instance-identifier my-database-instance \
  --engine-version 10.7 \
  --db-parameter-group-name my-postgres10 \
  --option-group-name my-postgres10 \
  --allow-major-version-upgrade \
  --apply-immediately

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.