doc-exports/docs/opengauss/api-ref/opengauss_api_1024.html

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:

• Learn how to authenticate this API.
• Understand the API in Using APIs.
• Obtain the required region and endpoint.

Constraints

• The values of the modified parameters must be within the default value range of the specified database version. For details about the value range of parameters, see "Modifying Parameters in a Parameter Template" in GaussDB User Guide.

URI

• URI format

  PUT https://{Endpoint}/opengauss/v3/{project_id}/instances/{instance_id}/configurations

• Example

  https://gaussdb.eu-de.otc.t-systems.com/opengauss/v3/0483b6b16e954cb88930a360d2c4e663/instances/dsfae23fsfdsae3435in01/configurations

• Parameter description

  Table 1 Parameter description

  Name	Mandatory	Description
  project_id	Yes	Project ID of a tenant in a region. To obtain this value, see Obtaining a Project ID.
  instance_id	Yes	DB instance ID.

Request

• Parameter description

  Table 2 Parameter description

  Name	Mandatory	Type	Description
  values	Yes	Map<String,String>	Parameter values defined by users based on a default parameter template For details, see Table 3.

  Table 3 values field data structure description

  Name	Mandatory	Type	Description
  key	Yes	String	Parameter name. For example, for the "failed_login_attempts": "4" parameter, the key is failed_login_attempts.
  value	Yes	String	Parameter value. For example, for the "failed_login_attempts": "4" parameter, the value is 4.

• Example request

  { 
      "values": { 
         "xxx": "10", 
         "yyy": "OFF" 
      }
  }

Response

• Normal response

  Table 4 Parameter description

  Name	Type	Description
  restart_required	Boolean	Whether a reboot is required. true: A reboot is required. false: A reboot is not required.

• Example normal response

  {
    "restart_required": false
  }

• Abnormal response

  For details, see Abnormal Request Results.

Status Code

• Normal

  200

• Abnormal

  For details, see Status Codes.

Error Code

For details, see Error Codes.

Parent topic: Parameter Configuration