Viewing VPC CDB-PostgreSQL server list
    • PDF

    Viewing VPC CDB-PostgreSQL server list

    • PDF

    Article summary

    The latest service changes have not yet been reflected in this content. We will update the content as soon as possible. Please refer to the Korean version for information on the latest updates.

    View the server list that can be checked in the Cloud Log Analytics service.

    Viewing VPC CDB-PostgreSQL server list

    View the list of CDB-PostgreSQL server instances (VM) on the VPC platform. Paging processing is available.

    Request URL

    GET https://cloudloganalytics.apigw.ntruss.com/api/{regionCode}-v1/vpc/servers/postgresql
    

    Request headers

    Header nameDescription
    x-ncp-apigw-timestampTime elapsed in milliseconds since January 1, 1970, 00:00:00 UTC
    The request is considered invalid if the time difference compared to the API Gateway server is more than 5 minutes
    x-ncp-apigw-timestamp:{Timestamp}
    x-ncp-apigw-api-keyKey value issued by APIGW
    x-ncp-apigw-api-key:{API Gateway API Key}
    x-ncp-iam-access-keyAccess Key ID value issued from NAVER Cloud Platform portal
    x-ncp-iam-access-key:{Account Access Key}
    x-ncp-apigw-signature-v2Signature encrypted with the Access Key ID value and Secret Key
    x-ncp-apigw-signature-v2:{API Gateway Signature}
    Content-TypeSpecifies the request body content type as application/json
    Content-Type: application/json

    Request parameters

    ParameterTypeRequiredDescription
    pageNoIntegerNPage number
    ex) 1, 2
    pageSizeIntegerNPage size
    ex) 10, 20

    Request examples

    GET https://cloudloganalytics.apigw.ntruss.com/api/{regionCode}-v1/vpc/servers/postgresql?pageNo=1&pageSize=10
    HOST: cloudloganalytics.apigw.ntruss.com
    Content-Type: application/json
    x-ncp-apigw-signature-v2: FJSBB4K3XnaGAvVe0Hzj3/2hfNWvgLHR1rQHW2Et2Rs=
    x-ncp-apigw-timestamp: 1593848345548
    x-ncp-iam-access-key: 11IKBWgQegM4DwiJL4mo
    
    curl -X GET "https://cloudloganalytics.apigw.ntruss.com/api/{regionCode}-v1/vpc/servers/postgresql?pageNo=1&pageSize=10" 
    -H "accept: application/json" 
    -H "x-ncp-iam-access-key: 11IKBWgQegM4DwiJL4mo" 
    -H "x-ncp-apigw-timestamp: 1593849262194" 
    -H "x-ncp-apigw-signature-v2: m/hJOfg92TqzOGyHJ++4vkimGT7un1/4+zLrLTvaVT4=" 
    

    Response examples

    {
      "code": 0,
      "message": "Your request has been processed normally",
      "result": {
        "pageSize": 10,
        "currentPage": 1,
        "totalPage": 1,
        "totalCount": 1,
        "isPaged": true,
        "dbServers": [
          {
            "standbyMasterServerName": "test-cla",
            "dbServerName": "test-cla",
            "databaseProductCode": "SW.VDBAS.DBAAS.LNX64.CNTOS.0703.PostgreSQL.5729.B050",
            "db_svr_rank": 0,
            "cloudDbServiceName": "test-cla",
            "dataStorageTypeCode": "SSD",
            "dataStorageSize": 10,
            "dataStorageSizeStr": "10GB",
            "dbInstanceNo": 1265456,
            "memorySize": "8GB",
            "dbStatusName": "running",
            "serverInstanceNo": 1265457,
            "dbServerIpAddress": "123.123.213.123",
            "cpuCount": 2,
            "dbServerRoleCode": "M",
            "dbServerType": "2vCPU, 8GB Mem",
            "usedDataStorageSize": 0,
            "uuid": "1265456-test-cla",
            "dbStatusNameValue": "Running",
            "dbStatusNameColor": "green",
            "dbServerRoleValue": "Master",
            "zoneNo": "2",
            "zoneName": null
          }
        ]
      }
    }
    

    Was this article helpful?

    Changing your password will log you out immediately. Use the new password to log back in.
    First name must have atleast 2 characters. Numbers and special characters are not allowed.
    Last name must have atleast 1 characters. Numbers and special characters are not allowed.
    Enter a valid email
    Enter a valid password
    Your profile has been successfully updated.