Modify Custom Parameter Group

To modify a parameter group in Amazon RDS, you can use the AWS Console, the AWS CLI, or the AWS SDK.

Using the AWS Console:

  1. Go to the Amazon RDS console.

  2. In the navigation pane, choose Parameter groups.

  3. Choose the parameter group that you want to modify.

  4. Under Actions, choose Edit. modify

  5. In the filter parameters search box, look for log_connections parameter. modify

  6. Click on the drop down in the Values column (if needed you can check the box to the left to activate the Values drop down). modify

  7. Change the value to 1 and click Save changes.

  8. Now clear the search box and look for another parameter by entering log_min_duration_statement. modify

  9. In the Values box, enter 4000. modify

  10. Click Save changes.

Note if you get an error message like “ Error saving: This parameter group cannot be modified because it is currently being applied to DB Instance” please wait a few minutes and retry your save action.

  1. Click the checkbox against the new parameter group and go to Parameter group actions drop down (on top right), choose Compare. modify

  2. Verify the changes from the default parameter group and then click Close. modify

(OPTIONAL) AWS CLI

Alternatively you can modify a custom parameter group using the AWS CLI as shown below:

Code