deleteCloudPostgresqlReadReplicaInstance
    • PDF

    deleteCloudPostgresqlReadReplicaInstance

    • PDF

    Article Summary

    VPC環境で利用できます。

    Cloud DB for PostgreSQL Read Replicaのサーバインスタンスを削除します。

    コマンド

    コマンド構文は、次のとおりです。

    ncloud vpostgresql deleteCloudPostgresqlReadReplicaInstance [regionCode] [cloudPostgresqlServerInstanceNo] [output]
    

    パラメータ

    パラメータについての説明は、次のとおりです。

    パラメータタイプ要否説明制約事項
    regionCodeStringNリージョンコード
    - regionCodeは、getRegionListアクションを通じて取得
    - default: getRegionList照会結果の最初のリージョンを選択
    -
    cloudPostgresqlServerInstanceNoStringY削除した Cloud DB for PostgreSQL Read Replicaのサーバインスタンス番号
    - Read Replicaサーバのみ削除可能
    - cloudPostgresqlServerInstanceNoは、getCloudPostgresqlInstanceListアクションを通じて取得
    -
    outputStringNレスポンス結果のフォーマットタイプ
    - options: xml | json
    - default: json
    -

    レスポンス

    レスポンスデータのタイプ

    • CloudPostgresqlInstanceListタイプ
    CloudPostgresqlInstanceList extends CommonResponse説明
    private Integer totalRows;照会されたリストの総数
    private List<CloudPostgresqlInstance> cloudPostgresqlInstanceList = new ArrayList<>();Cloud DB for PostgreSQLインスタンスリスト
    • CloudPostgresqlInstanceタイプ
    CloudPostgresqlInstance説明
    private String cloudPostgresqlInstanceNo;Cloud DB for PostgreSQLのインスタンス番号
    private String cloudPostgresqlServiceName;Cloud DB for PostgreSQLのサービス名
    private String cloudPostgresqlInstanceStatusName;Cloud DB for PostgreSQLインスタンスステータス名
    - creating
    - deleted
    - deleting
    - downgrading
    - pending
    - recovering
    - reinstalling
    - restarting
    - running
    - settingup
    - shuttingdown
    - stopped
    - upgrading
    private CommonCode cloudPostgresqlInstanceStatus;Cloud DB for PostgreSQLインスタンスステータスコード
    - INIT (initiate)
    - CREAT (created)
    - DEL (deleted)
    private CommonCode cloudPostgresqlInstanceOperation;Cloud DB for PostgreSQLインスタンス Operationコード
    - CREAT (create)
    - DEL (delete)
    - FO (failover)
    - NULL (no operation)
    - SETUP (setup)
    - UPGD (upgrade)
    - DWGD (downgrade)
    - BKP (backup)
    private String cloudPostgresqlImageProductCode;Cloud DB for PostgreSQLの画像商品コード
    private String engineVersion;Cloud DB for PostgreSQLエンジンバージョン
    private String license;Cloud DB for PostgreSQLライセンス
    private Integer cloudPostgresqlPort;Cloud DB for PostgreSQLポート
    private Boolean isHa;高可用性の有無
    private Boolean isMultiZone;マルチゾーンの有無
    private Boolean isBackup;バックアップの有無
    private Integer backupFileRetentionPeriod;バックアップファイルの保存期間
    private String backupTime;バックアップ時間
    private Date createDate;作成日
    private AccessControlGroupNoList accessControlGroupNoList;ACG番号リスト
    private CloudPostgresqlConfigList cloudPostgresqlConfigList;Cloud DB for PostgreSQL Configリスト
    private List<CloudPostgresqlServerInstance> cloudPostgresqlServerInstanceList;Cloud DB for PostgreSQLサーバインスタンスリスト
    • AccessControlGroupNoListタイプ
    AccessControlGroupNoList説明
    private List<String> accessControlGroupNoList = new ArrayList<>();ACG番号リスト
    • CloudPostgresqlConfigListタイプ
    CloudPostgresqlConfigList説明
    private List<String> cloudPostgresqlConfigList = new ArrayList<>();Cloud DB for PostgreSQL Configリスト
    • CloudPostgresqlServerInstanceタイプ
    CloudPostgresqlServerInstance説明
    private String cloudPostgresqlServerInstanceNo;Cloud DB for PostgreSQLのサーバインスタンス番号
    private String cloudPostgresqlServerName;Cloud DB for PostgreSQLのサーバ名
    private CommonCode cloudPostgresqlServerRole;Cloud DB for PostgreSQLサーバ役割
    private String cloudPostgresqlServerInstanceStatusName;Cloud DB for PostgreSQLサーバインスタンスステータス名
    - creating
    - deleted
    - deleting
    - downgrading
    - pending
    - recovering
    - reinstalling
    - restarting
    - running
    - settingup
    - shuttingdown
    - stopped
    - upgrading
    - downgrading
    private CommonCode cloudPostgresqlServerInstanceStatus;Cloud DB for PostgreSQLサーバインスタンスステータスコード
    - DEL (deleted)
    - PEND (pending)
    - RUN (running)
    - STOP (stopped)
    - FSTOP (failure stopped)
    private CommonCode cloudPostgresqlServerInstanceOperation;Cloud DB for PostgreSQLサーバインスタンス Operationコード
    - NOOP (no operation)
    - CREAT (create)
    - START (start)
    - RSTRT (restart)
    - SETUP (setup)
    - STOP (stop)
    - FO (failover)
    - DEL (delete)
    - UPGD (upgrade)
    - DWGD (downgrade)
    - RISTL (reinstall)
    private String cloudPostgresqlProductCode;Cloud DB for PostgreSQLの商品コード
    private String regionCode;リージョンコード
    private String zoneCode;Zoneコード
    private String vpcNo;VPC番号
    private String subnetNo;Subnet番号
    private Boolean isPublicSubnet;Public Subnetの有無
    private String publicDomain;グローバルドメイン名
    private String privateDomain;プライベートドメイン名
    private CommonCode dataStorageType;データストレージタイプ
    private Boolean isStorageEncryption;データストレージの暗号化の有無
    private Long dataStorageSize;データストレージサイズ
    private Long usedDataStorageSize;使用中のデータストレージサイズ
    private Integer cpuCount;CPU数
    private Long memorySize;メモリサイズ
    private Date uptime;VM起動完了時間
    private Date createDate;作成日

    呼び出しとレスポンス例を説明します。

    呼び出し例

    呼び出し例は、次のとおりです。

    ncloud vpostgresql deleteCloudPostgresqlReadReplicaInstance --regionCode KR --cloudPostgresqlServerInstanceNo ****019
    

    レスポンス例

    レスポンス例は、次のとおりです。

    レスポンス結果フォーマットタイプ(output)が jsonのとき

    {
      "deleteCloudPostgresqlReadReplicaInstanceResponse": {
        "requestId": "7a328127-6348-42e4-a2ff-9966568f479a",
        "returnCode": 0,
        "returnMessage": "success",
        "totalRows": 1,
        "cloudPostgresqlInstanceList": {
          "cloudPostgresqlInstance": {
            "cloudPostgresqlInstanceNo": "****925",
            "cloudPostgresqlServiceName": "test-****",
            "cloudPostgresqlInstanceStatusName": "running",
            "cloudPostgresqlInstanceStatus": {
              "code": "CREAT",
              "codeName": "CLOUD DATABASE(VPC) Created State"
            },
            "cloudPostgresqlInstanceOperation": {
              "code": "NULL",
              "codeName": "CLOUD DATABASE(VPC) Null OP"
            },
            "cloudPostgresqlImageProductCode": "SW.VPGSL.OS.LNX64.CNTOS.0708.PGSQL.133.B050",
            "engineVersion": "PostgreSQL 13.3",
            "license": "PostgreSQL License",
            "cloudPostgresqlPort": 15432,
            "isHa": true,
            "isMultiZone": true,
            "isBackup": true,
            "backupFileRetentionPeriod": 10,
            "backupTime": "02:00",
            "createDate": "2021-08-30T18:00:00+0900",
            "accessControlGroupNoList": [
              "****48"
            ],
            "cloudPostgresqlServerInstanceList": [
              {
                "cloudPostgresqlServerInstanceNo": "****926",
                "cloudPostgresqlServerName": "test-****-001-gcb",
                "cloudPostgresqlServerRole": {
                  "code": "M",
                  "codeName": "Primary"
                },
                "cloudPostgresqlServerInstanceStatusName": "running",
                "cloudPostgresqlServerInstanceStatus": {
                  "code": "RUN",
                  "codeName": "CLOUD DATABASE(VPC) Server Running State"
                },
                "cloudPostgresqlServerInstanceOperation": {
                  "code": "NOOP",
                  "codeName": "CLOUD DATABASE(VPC) Server Null OP"
                },
                "cloudPostgresqlProductCode": "SVR.VPGSL.DBSVR.STAND.C002.M004.NET.SSD.B050.G001",
                "regionCode": "KR",
                "zoneCode": "KR-1",
                "vpcNo": "****87",
                "subnetNo": "****49",
                "isPublicSubnet": true,
                "privateDomain": "pg-****.vpc-cdb-kr.ntruss.com",
                "dataStorageType": {
                  "code": "SSD",
                  "codeName": "SSD"
                },
                "isStorageEncryption": true,
                "dataStorageSize": 10737418240,
                "usedDataStorageSize": 4365672448,
                "cpuCount": 2,
                "memorySize": 4294967296,
                "uptime": "2021-08-30T18:10:00+0900",
                "createDate": "2021-08-30T18:00:00+0900"
              },
              {
                "cloudPostgresqlServerInstanceNo": "****932",
                "cloudPostgresqlServerName": "test-****-002-gcc",
                "cloudPostgresqlServerRole": {
                  "code": "H",
                  "codeName": "Secondary"
                },
                "cloudPostgresqlServerInstanceStatusName": "running",
                "cloudPostgresqlServerInstanceStatus": {
                  "code": "RUN",
                  "codeName": "CLOUD DATABASE(VPC) Server Running State"
                },
                "cloudPostgresqlServerInstanceOperation": {
                  "code": "NOOP",
                  "codeName": "CLOUD DATABASE(VPC) Server Null OP"
                },
                "cloudPostgresqlProductCode": "SVR.VPGSL.DBSVR.STAND.C002.M004.NET.SSD.B050.G001",
                "regionCode": "KR",
                "zoneCode": "KR-2",
                "vpcNo": "****87",
                "subnetNo": "****51",
                "isPublicSubnet": true,
                "privateDomain": "pg-****.vpc-cdb-kr.ntruss.com",
                "dataStorageType": {
                  "code": "SSD",
                  "codeName": "SSD"
                },
                "isStorageEncryption": true,
                "dataStorageSize": 10737418240,
                "usedDataStorageSize": 4365434880,
                "cpuCount": 2,
                "memorySize": 4294967296,
                "uptime": "2021-08-30T18:10:00+0900",
                "createDate": "2021-08-30T18:00:00+0900"
              },
              {
                "cloudPostgresqlServerInstanceNo": "****019",
                "cloudPostgresqlServerName": "test-****-003-gcd",
                "cloudPostgresqlServerRole": {
                  "code": "S",
                  "codeName": "Read Replica"
                },
                "cloudPostgresqlServerInstanceStatusName": "deleting",
                "cloudPostgresqlServerInstanceStatus": {
                  "code": "RUN",
                  "codeName": "CLOUD DATABASE(VPC) Server Running State"
                },
                "cloudPostgresqlServerInstanceOperation": {
                  "code": "DEL",
                  "codeName": "CLOUD DATABASE(VPC) Server Delete OP"
                },
                "cloudPostgresqlProductCode": "SVR.VPGSL.DBSVR.STAND.C002.M004.NET.SSD.B050.G001",
                "regionCode": "KR",
                "zoneCode": "KR-2",
                "vpcNo": "****87",
                "subnetNo": "****51",
                "isPublicSubnet": true,
                "privateDomain": "pg-1oii3.beta-vpc-cdb-kr.ntruss.com",
                "dataStorageType": {
                  "code": "SSD",
                  "codeName": "SSD"
                },
                "isStorageEncryption": true,
                "dataStorageSize": 10737418240,
                "usedDataStorageSize": 2217943040,
                "cpuCount": 2,
                "memorySize": 4294967296,
                "uptime": "2021-08-30T18:40:00+0900",
                "createDate": "2021-08-30T18:30:00+0900"
              }
            ]
          }
        }
      }
    }
    

    レスポンス結果フォーマットタイプ(output)が xmlの場合

    <deleteCloudPostgresqlReadReplicaInstanceResponse>
        <requestId>7a328127-6348-42e4-a2ff-9966568f479a</requestId>
        <returnCode>0</returnCode>
        <returnMessage>success</returnMessage>
        <totalRows>1</totalRows>
        <cloudPostgresqlInstanceList>
            <cloudPostgresqlInstance>
                <cloudPostgresqlInstanceNo>****925</cloudPostgresqlInstanceNo>
                <cloudPostgresqlServiceName>test-****</cloudPostgresqlServiceName>
                <cloudPostgresqlInstanceStatusName>running</cloudPostgresqlInstanceStatusName>
                <cloudPostgresqlInstanceStatus>
                    <code>CREAT</code>
                    <codeName>CLOUD DATABASE(VPC) Created State</codeName>
                </cloudPostgresqlInstanceStatus>
                <cloudPostgresqlInstanceOperation>
                    <code>NULL</code>
                    <codeName>CLOUD DATABASE(VPC) Null OP</codeName>
                </cloudPostgresqlInstanceOperation>
                <cloudPostgresqlImageProductCode>SW.VPGSL.OS.LNX64.CNTOS.0708.PGSQL.133.B050</cloudPostgresqlImageProductCode>
                <engineVersion>PostgreSQL 13.3</engineVersion>
                <license>PostgreSQL License</license>
                <cloudPostgresqlPort>15432</cloudPostgresqlPort>
                <isHa>true</isHa>
                <isMultiZone>true</isMultiZone>
                <isBackup>true</isBackup>
                <backupFileRetentionPeriod>10</backupFileRetentionPeriod>
                <backupTime>02:00</backupTime>
                <createDate>2021-08-30T18:00:00+0900</createDate>
                <accessControlGroupNoList>
                    <accessControlGroupNo>****48</accessControlGroupNo>
                </accessControlGroupNoList>
                <cloudPostgresqlServerInstanceList>
                    <cloudPostgresqlServerInstance>
                        <cloudPostgresqlServerInstanceNo>****926</cloudPostgresqlServerInstanceNo>
                        <cloudPostgresqlServerName>test-****-001-gcb</cloudPostgresqlServerName>
                        <cloudPostgresqlServerRole>
                            <code>M</code>
                            <codeName>Primary</codeName>
                        </cloudPostgresqlServerRole>
                        <cloudPostgresqlServerInstanceStatusName>running</cloudPostgresqlServerInstanceStatusName>
                        <cloudPostgresqlServerInstanceStatus>
                            <code>RUN</code>
                            <codeName>CLOUD DATABASE(VPC) Server Running State</codeName>
                        </cloudPostgresqlServerInstanceStatus>
                        <cloudPostgresqlServerInstanceOperation>
                            <code>NOOP</code>
                            <codeName>CLOUD DATABASE(VPC) Server Null OP</codeName>
                        </cloudPostgresqlServerInstanceOperation>
                        <cloudPostgresqlProductCode>SVR.VPGSL.DBSVR.STAND.C002.M004.NET.SSD.B050.G001</cloudPostgresqlProductCode>
                        <regionCode>KR</regionCode>
                        <zoneCode>KR-1</zoneCode>
                        <vpcNo>****87</vpcNo>
                        <subnetNo>****49</subnetNo>
                        <isPublicSubnet>true</isPublicSubnet>
                        <privateDomain>pg-****.vpc-cdb-kr.ntruss.com</privateDomain>
                        <dataStorageType>
                            <code>SSD</code>
                            <codeName>SSD</codeName>
                        </dataStorageType>
                        <isStorageEncryption>true</isStorageEncryption>
                        <dataStorageSize>10737418240</dataStorageSize>
                        <usedDataStorageSize>4365672448</usedDataStorageSize>
                        <cpuCount>2</cpuCount>
                        <memorySize>4294967296</memorySize>
                        <uptime>2021-08-30T18:10:00+0900</uptime>
                        <createDate>2021-08-30T18:00:00+0900</createDate>
                    </cloudPostgresqlServerInstance>
                    <cloudPostgresqlServerInstance>
                        <cloudPostgresqlServerInstanceNo>****932</cloudPostgresqlServerInstanceNo>
                        <cloudPostgresqlServerName>test-****-002-gcc</cloudPostgresqlServerName>
                        <cloudPostgresqlServerRole>
                            <code>H</code>
                            <codeName>Secondary</codeName>
                        </cloudPostgresqlServerRole>
                        <cloudPostgresqlServerInstanceStatusName>running</cloudPostgresqlServerInstanceStatusName>
                        <cloudPostgresqlServerInstanceStatus>
                            <code>RUN</code>
                            <codeName>CLOUD DATABASE(VPC) Server Running State</codeName>
                        </cloudPostgresqlServerInstanceStatus>
                        <cloudPostgresqlServerInstanceOperation>
                            <code>NOOP</code>
                            <codeName>CLOUD DATABASE(VPC) Server Null OP</codeName>
                        </cloudPostgresqlServerInstanceOperation>
                        <cloudPostgresqlProductCode>SVR.VPGSL.DBSVR.STAND.C002.M004.NET.SSD.B050.G001</cloudPostgresqlProductCode>
                        <regionCode>KR</regionCode>
                        <zoneCode>KR-2</zoneCode>
                        <vpcNo>****87</vpcNo>
                        <subnetNo>****51</subnetNo>
                        <isPublicSubnet>true</isPublicSubnet>
                        <privateDomain>pg-****.vpc-cdb-kr.ntruss.com</privateDomain>
                        <dataStorageType>
                            <code>SSD</code>
                            <codeName>SSD</codeName>
                        </dataStorageType>
                        <isStorageEncryption>true</isStorageEncryption>
                        <dataStorageSize>10737418240</dataStorageSize>
                        <usedDataStorageSize>4365434880</usedDataStorageSize>
                        <cpuCount>2</cpuCount>
                        <memorySize>4294967296</memorySize>
                        <uptime>2021-08-30T18:10:00+0900</uptime>
                        <createDate>2021-08-30T18:00:00+0900</createDate>
                    </cloudPostgresqlServerInstance>
                    <cloudPostgresqlServerInstance>
                        <cloudPostgresqlServerInstanceNo>****019</cloudPostgresqlServerInstanceNo>
                        <cloudPostgresqlServerName>test-****-003-gcd</cloudPostgresqlServerName>
                        <cloudPostgresqlServerRole>
                            <code>S</code>
                            <codeName>Read Replica</codeName>
                        </cloudPostgresqlServerRole>
                        <cloudPostgresqlServerInstanceStatusName>deleting</cloudPostgresqlServerInstanceStatusName>
                        <cloudPostgresqlServerInstanceStatus>
                            <code>RUN</code>
                            <codeName>CLOUD DATABASE(VPC) Server Running State</codeName>
                        </cloudPostgresqlServerInstanceStatus>
                        <cloudPostgresqlServerInstanceOperation>
                            <code>DEL</code>
                            <codeName>CLOUD DATABASE(VPC) Server Delete OP</codeName>
                        </cloudPostgresqlServerInstanceOperation>
                        <cloudPostgresqlProductCode>SVR.VPGSL.DBSVR.STAND.C002.M004.NET.SSD.B050.G001</cloudPostgresqlProductCode>
                        <regionCode>KR</regionCode>
                        <zoneCode>KR-2</zoneCode>
                        <vpcNo>****87</vpcNo>
                        <subnetNo>****51</subnetNo>
                        <isPublicSubnet>true</isPublicSubnet>
                        <privateDomain>pg-1oii3.beta-vpc-cdb-kr.ntruss.com</privateDomain>
                        <dataStorageType>
                            <code>SSD</code>
                            <codeName>SSD</codeName>
                        </dataStorageType>
                        <isStorageEncryption>true</isStorageEncryption>
                        <dataStorageSize>10737418240</dataStorageSize>
                        <usedDataStorageSize>2217943040</usedDataStorageSize>
                        <cpuCount>2</cpuCount>
                        <memorySize>4294967296</memorySize>
                        <uptime>2021-08-30T18:40:00+0900</uptime>
                        <createDate>2021-08-30T18:30:00+0900</createDate>
                    </cloudPostgresqlServerInstance>
                </cloudPostgresqlServerInstanceList>
            </cloudPostgresqlInstance>
        </cloudPostgresqlInstanceList>
    </deleteCloudPostgresqlReadReplicaInstanceResponse>
    

    この記事は役に立ちましたか?

    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.