rds-modify-db-parameter-group

Description

Updates the parameters in a parameter group. You can update up to 20 values per call.

	Note
	Amazon RDS does not support passing multiple comma-delimited parameter values for a single parameter.

	Note
	The `apply-immediately` method can be used only for dynamic parameters; the `pending-reboot` method can be used with MySQL and Oracle DB Instances for either dynamic or static parameters. For Microsoft SQL Server DB Instances, the `pending-reboot` parameter can be used only for static parameters.

Syntax

rds-modify-db-parameter-group DBParameterGroupName

-p (--parameters) "name=value, value=value, method=value" [-p (--parameters) "name=value, value=value, method=value" ...]] [General Options]

Options

Name Description Required

Name	Description	Required
`DBParameterGroupName`	DB Parameter Group identifier. Stored as a lowercase string. This value can also be passed using the `--db-parameter-group-name` named parameter. Constraints: Must contain from 1 to 255 alphanumeric characters or hyphens. First character must be a letter. Cannot end with a hyphen or contain two consecutive hyphens.	Yes
`-p` `--parameters` `"name=value, value=value, method=value"`	A string containing a series of parameter names, values, and the update method for the parameter update. The first --parameters argument is required; subsequent arguments are optional. A maximum of 20 parameters may be updated in a single call to the `rds-modify-parameter-group` command. Valid values (method): `immediate` \| `pending-reboot`.	Yes

DBParameterGroupName

DB Parameter Group identifier. Stored as a lowercase string.

This value can also be passed using the --db-parameter-group-name named parameter.

Constraints: Must contain from 1 to 255 alphanumeric characters or hyphens. First character must be a letter. Cannot end with a hyphen or contain two consecutive hyphens.

Yes

-p

--parameters "name=value, value=value, method=value"

A string containing a series of parameter names, values, and the update method for the parameter update. The first --parameters argument is required; subsequent arguments are optional. A maximum of 20 parameters may be updated in a single call to the rds-modify-parameter-group command.

Valid values (method): immediate | pending-reboot.

Yes

Output

The command returns the following information:

Group Name—The name of the parameter group that was modified.

Examples

Modify Parameters in a Parameter Group

This example shows how to modify a group of parameters in a parameter group.

PROMPT> rds-modify-db-parameter-group mydbparametergroup --parameters "name=max_user_connections, value=24, method=pending-reboot" "name=max_allowed_packet, value=1024, method=immediate"