Help Center/ GaussDB/ API Reference/ APIs (Recommended)/ Parameter Configuration/ Modifying Parameters of a Specified DB Instance
Updated on 2025-08-19 GMT+08:00

Modifying Parameters of a Specified DB Instance

Function

This API is used to modify parameters in the parameter template of a specified DB instance. Before calling this API:

Constraints

The values of the modified parameters must be within the default value range of the specified database version. For details about the range of parameter values, see "Viewing and Modifying Instance Parameters" in the GaussDB User Guide.

URI

PUT /v3/{project_id}/instances/{instance_id}/configurations

Table 1 Parameter description

Name

Mandatory

Description

project_id

Yes

Definition

Project ID of a tenant in a region.

To obtain the value, see Obtaining a Project ID.

Constraints

N/A

Range

The value can contain 32 characters. Only letters and digits are allowed.

Default Value

N/A

instance_id

Yes

Definition

Instance ID, which uniquely identifies an instance.

Constraints

N/A

Range

The value can contain 36 characters. Only letters and digits are allowed.

Default Value

N/A

Request Parameters

Table 2 Parameter description

Name

Mandatory

Type

Description

values

Yes

Map<String,String>

Definition

Parameter values defined by users based on the default parameter templates.

Example: For failed_login_attempts: 4, failed_login_attempts indicates the parameter name, and 4 indicated the changed parameter value.

Constraints

N/A

Response Parameters

Table 3 Parameter description

Name

Type

Description

restart_required

Boolean

Definition

Whether the instance needs to be rebooted.

Range

  • true: A reboot is required.
  • false: A reboot is not required.

job_id

String

Definition

Task ID for modifying the parameters of a specified instance.

Range

N/A

Example Request

  • Changing the value of failed_login_attempts to 4 (The change is applied without a DB instance reboot.)
    PUT https://gaussdb-opengauss.ap-southeast-1.myhuaweicloud.com/v3/0483b6b16e954cb88930a360d2c4e663/instances/dsfae23fsfdsae3435in01/configurations
    { 
        "values": { 
            "failed_login_attempts": "4"
        }
    }
  • Changing the value of track_activity_query_size to 2048 and the value of max_replication_slots to 25 (The changes are applied after the instance is rebooted.)
    PUT https://gaussdb-opengauss.ap-southeast-1.myhuaweicloud.com/v3/0483b6b16e954cb88930a360d2c4e663/instances/dsfae23fsfdsae3435in01/configurations
    {
        "values": {
            "track_activity_query_size": "2048",
            "max_replication_slots": "25"
        }
    }

Example Response

  • Parameter modified (The instance does not need to be rebooted).
    {
      "restart_required": false,
      "job_id": "5a08604b-7820-4cf1-9356-b378c4fac694"
    }
  • Parameter modified (The instance needs to be rebooted).
    {
      "restart_required": true,
      "job_id": "e51532df-b94d-4fbc-9cf0-aea030ade45d"
    }

Status Codes

Error Codes

For details, see Error Codes.