Menu
Amazon Redshift
API Reference (API Version 2012-12-01)

ResetClusterParameterGroup

Sets one or more parameters of the specified parameter group to their default values and sets the source values of the parameters to "engine-default". To reset the entire parameter group specify the ResetAllParameters parameter. For parameter changes to take effect you must reboot any associated clusters.

Request Parameters

For information about the parameters that are common to all actions, see Common Parameters.

ParameterGroupName

The name of the cluster parameter group to be reset.

Type: String

Required: Yes

Parameters.Parameter.N

An array of names of parameters to be reset. If ResetAllParameters option is not used, then at least one parameter name must be supplied.

Constraints: A maximum of 20 parameters can be reset in a single request.

Type: Array of Parameter objects

Required: No

ResetAllParameters

If true, all parameters in the specified parameter group will be reset to their default values.

Default: true

Type: Boolean

Required: No

Response Elements

The following elements are returned by the service.

ParameterGroupName

The name of the cluster parameter group.

Type: String

ParameterGroupStatus

The status of the parameter group. For example, if you made a change to a parameter group name-value pair, then the change could be pending a reboot of an associated cluster.

Type: String

Errors

For information about the errors that are common to all actions, see Common Errors.

ClusterParameterGroupNotFound

The parameter group name does not refer to an existing parameter group.

HTTP Status Code: 404

InvalidClusterParameterGroupState

The cluster parameter group action can not be completed because another task is in progress that involves the parameter group. Wait a few moments and try the operation again.

HTTP Status Code: 400

Example

Sample Request

https://redshift.us-east-1.amazonaws.com/
    ?Action=ResetClusterParameterGroup
    &ParameterGroupName=parametergroup1
    &Parameters.member.1.ParameterName=extra_float_digits
    &Version=2012-12-01
    &x-amz-algorithm=AWS4-HMAC-SHA256
    &x-amz-credential=AKIAIOSFODNN7EXAMPLE/20121208/us-east-1/redshift/aws4_request
    &x-amz-date=20121208T020847Z
    &x-amz-signedheaders=content-type;host;x-amz-date

Sample Response

<ResetClusterParameterGroupResponse xmlns="http://redshift.amazonaws.com/doc/2012-12-01/">
  <ResetClusterParameterGroupResult>
    <ParameterGroupStatus>Your parameter group has been updated. Updates to dynamic parameters will be applied immediately. Updates to static parameters will be applied when you reboot the associated Clusters.</ParameterGroupStatus>
    <ParameterGroupName>parametergroup1</ParameterGroupName>
  </ResetClusterParameterGroupResult>
  <ResponseMetadata>
    <RequestId>625d23c1-40dc-11e2-8a25-eb010998df4e</RequestId>
  </ResponseMetadata>
</ResetClusterParameterGroupResponse>

See Also

For more information about using this API in one of the language-specific AWS SDKs, see the following: