7
votes

How to change the parameter group of an AWS RDS instance?

I've created a new parameter group. So now I have default and my new one.

In RDS Dashboard > Instances, on my instance under configuration details I see that default group is selected.

But don't see anywhere to edit the group on the instance. Clicking the group under configuration details loads the parameter group page.

This entire article never actually mentions how to change the group on the instance. http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_WorkingWithParamGroups.html

2

2 Answers

15
votes

To change anything like that you click on the RDS instance and then select "Modify". In the Modify screen you can select a different parameter group.

1
votes

See the "Modifying a DB Instance" section of the docs.

enter image description here

That page also goes over how to modify the db instance via the CLI, e.g.

aws rds modify-db-instance --db-instance-identifier <your instance name> --db-parameter-group-name <your PG name> 

See the docs for the other options you can specify in the modify-db-instance command.