1
0
forked from docs/doc-exports
doc-exports/docs/opengauss/api-ref/opengauss_newapi_0004.html
Ru, Li Yi d97aea4dd2 opengauss_api
Reviewed-by: Boka, Ladislav <ladislav.boka@t-systems.com>
Co-authored-by: Ru, Li Yi <liyiru7@huawei.com>
Co-committed-by: Ru, Li Yi <liyiru7@huawei.com>
2024-09-06 09:04:21 +00:00

17 KiB

Obtaining the Parameters of a Specified DB Instance

Function

This API is used to obtain parameters of a specified DB instance. Before calling this API:

URI

  • URI format

    GET https://{Endpoint}/v3/{project_id}/instances/{instance_id}/configurations

  • Parameter description
    Table 1 Parameter description

    Parameter

    Mandatory

    Type

    Description

    project_id

    Yes

    String

    Project ID of a tenant in a region.

    To obtain this value, see Obtaining a Project ID.

    instance_id

    Yes

    String

    DB instance ID.

Request

None

Response

  • Normal response
    Table 2 Parameter description

    Parameter

    Type

    Description

    datastore_version

    String

    Engine version.

    datastore_name

    String

    Engine name.

    created

    String

    Creation time in the "yyyy-MM-dd HH:mm:ss" format.

    updated

    String

    Update time in the "yyyy-MM-ddHH:mm:ss" format.

    configuration_parameters

    Array of objects

    Parameters defined by users based on the default parameter templates. For details, see Table 3.

    Table 3 configuration_parameters field data structure description

    Parameter

    Type

    Description

    name

    String

    Parameter name.

    value

    String

    Parameter value.

    restart_required

    Boolean

    Whether a reboot is required after the parameter is modified.

    value_range

    String

    Parameter value range.

    type

    String

    Parameter type. The value can be string, integer, boolean, list, or float.

    Value:

    • string
    • integer
    • boolean
    • list
    • float

    description

    String

    Parameter description.

Example Response

  • Normal response
    {
        "created": "2022-04-11 10:46:59",
        "updated": "2022-04-11 10:46:59",
        "datastore_version": "2.0",
        "datastore_name": "GaussDB(for openGauss)",
        "configuration_parameters": [
            {
                "name": "audit_system_object",
                "value": "12295",
                "type": "integer",
                "description": "Whether to audit the CREATE, DROP, and ALTER operations on database objects",
                "restart_required": false,
                "value_range": "0-2097151"
            }
        ]
    }

Status Code

Error Code

For details, see Error Codes.