Menu
Amazon Relational Database Service
Command Line Interface Reference (API Version 2014-10-31)

rds-reset-db-parameter-group

The Amazon RDS Command Line Interface (RDS CLI) has been deprecated. Instead, use the AWS CLI for RDS. To learn how to download and use the AWS CLI, see AWS Command Line Interface User Guide. For RDS commands available in the AWS CLI, see AWS CLI Reference for Amazon RDS.

The AWS CLI does not currently support the DownloadCompleteDBLogFile REST API action. To download an entire log file at once, rather than in parts using the download-db-log-file-portion command, use the last published RDS CLI and the rds-download-db-logfile command.

Description

Resets individual parameters or all parameters in a parameter group to engine defaults.

Syntax

rds-reset-db-parameter-group db-parameter-group-name

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

[--reset-all-parameters ] [General Options]

Options

Name Description Required

--db-parameter-group-name value

DB parameter group identifier.

This parameter is the default parameter and can be passed as the first value in the command and without a parameter name, for example: rds-reset-db-parameter-group my-db-parameter-group-name.

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, method=value"

A string containing a series of parameter names, values, and apply methods. A maximum of 20 parameters may be reset in a single call to the rds-reset-db-parameter-group command.

Valid values (for apply method): immediate | pending-reboot

Constraints: Cannot be specified if --reset-all-parameters is specified.

Conditional

--reset-all-parameters

Specifies that all parameters in the group should be reset to their defaults.

Constraints: Cannot be specified if --parameters string is specified.

Conditional

Output

The command returns the following information:

Note

Output values list the possible values returned by CLI commands. Not all values are returned for every call to a command. If a value is null or empty, it will not be included in the command output. For example, CLI commands to create or restore a DB instance will not return the Endpoint Address value because that value is null until the DB instance has finished being created or restored.

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

Examples

Reset Parameters in a Parameter Group

This example shows how to reset some parameters in a parameter group.

Copy
PROMPT> rds-reset-db-parameter-group mydbparametergroup --parameters "name=max_user_connections, method=pending-reboot" "name=max_allowed_packet, method=immediate"

Reset Parameters in a Parameter Group

This example shows how to reset all parameters in a parameter group.

Copy
PROMPT> rds-reset-db-parameter-group mydbparamgrp --reset-all-parameters