Amazon Relational Database Service
Command Line Interface Reference (API Version 2013-02-12)
« PreviousNext »
View the PDF for this guide.Go to the AWS Discussion Forum for this product.Did this page help you?  Yes | No |  Tell us about it...

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.

Syntax

rds-modify-db-parameter-group DBParameterGroupName

-p (--parameters) "name=value, value=value, method=value"[,

"name=value, value=value, method=value"][,

...]

[General Options]

Options

NameDescriptionRequired

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.

To obtain a list of the parameters that make up a parameter group, with their values, use the rds-describe-db-parameters command. Only parameters that are marked as modifiable can be changed.

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

If immediate, the change takes effect immediately. If pending-reboot, the change takes effect the next time that the DB Instance is rebooted.

The immediate 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.

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"