Skip to main content

GCP PostgreSQL instance restore​

Select

Customer Managed

This operation is used to submit GCP Postgres instance restores.

Request Body
  • taskInfo object
  • associations object[]
  • clientName string required

    Name of the cloud account

  • instanceName string required

    Name of the instance

  • displayName string

    Display name of the cloud account

  • _type_ string required

    Possible values: [INSTANCE_ENTITY, BACKUPSET_ENTITY, SUBCLIENT_ENTITY]

  • backupsetName string required

    Default value: DumpBasedBackupSet

  • applicationId integer required

    Default value: 125

  • isDefaultBackupSet boolean

    Default value: true

  • entityName string

    Name of the entity from which restore is submitted

  • task object
  • taskType string

    Possible values: [IMMEDIATE, SCHEDULE]

  • subTasks object[]
  • subTask object
  • subTaskType string

    Default value: RESTORE

  • operationType string

    Default value: RESTORE

  • options object
  • restoreOptions object
  • browseOption object required
  • commCellId integer
  • backupset object
  • clientName string
  • backupsetName string
  • destination object
  • destClient object required
  • clientName string

    Destination Client Name

  • destinationInstance object required
  • instanceName string

    Destinaton Instance name

  • applicationId integer

    Default value: 125

  • clientName string

    Destination Client Name

  • displayName string

    Destination Client Display Name

  • fileOption object required
  • sourceItem string[]

    List of databases to restore

  • postgresRstOption object required
  • tableLevelRestore boolean

    Default value: false

  • refTime object
  • time integer
  • fromTime object
  • time integer
  • pointOfTime object
  • time integer
  • pointInTime boolean

    Default value: false

  • commonOpts object
  • notifyUserOnJobCompletion boolean

    Default value: true

  • prePostOpts object
  • preRecoveryCommand string
  • postRecoveryCommand string
  • runPostWhenFail boolean
Responses

OK

Schema
  • taskId integer
  • jobIds string[]
POST /createtask

Authorization

type: apiKeyname: Authtokenin: header

Request

Click Edit to configure Base URL
https://CommandCenterHostName/commandcenter/api
Security Scheme
token
Body
{

  "taskInfo": {

    "associations": [

      {

        "clientName": "string",

        "instanceName": "string",

        "displayName": "string",

        "_type_": "INSTANCE_ENTITY",

        "backupsetName": "DumpBasedBackupSet",

        "applicationId": 125,

        "isDefaultBackupSet": true,

        "entityName": "string"

      }

    ],

    "task": {

      "taskType": "IMMEDIATE"

    },

    "subTasks": [

      {

        "subTask": {

          "subTaskType": "RESTORE",

          "operationType": "RESTORE"

        },

        "options": {

          "restoreOptions": {

            "browseOption": {

              "commCellId": 0,

              "backupset": {

                "clientName": "string",

                "backupsetName": "string"

              }

            },

            "destination": {

              "destClient": {

                "clientName": "string"

              },

              "destinationInstance": {

                "instanceName": "string",

                "applicationId": 125,

                "clientName": "string",

                "displayName": "string"

              }

            },

            "fileOption": {

              "sourceItem": [

                "string"

              ]

            },

            "postgresRstOption": {

              "tableLevelRestore": false,

              "refTime": {

                "time": 0

              },

              "fromTime": {

                "time": 0

              },

              "pointOfTime": {

                "time": 0

              },

              "pointInTime": false

            }

          },

          "commonOpts": {

            "notifyUserOnJobCompletion": true,

            "prePostOpts": {

              "preRecoveryCommand": "string",

              "postRecoveryCommand": "string",

              "runPostWhenFail": true

            }

          }

        }

      }

    ]

  }

}

curl -L -X POST 'https://CommandCenterHostName/commandcenter/api/createTask' \
-H 'Content-Type: application/json' \
-H 'Accept: application/json' \
-H 'Authtoken: <API_KEY_VALUE>' \
--data-raw '{
  "taskInfo": {
    "associations": [
      {
        "clientName": "string",
        "instanceName": "string",
        "displayName": "string",
        "_type_": "INSTANCE_ENTITY",
        "backupsetName": "DumpBasedBackupSet",
        "applicationId": 125,
        "isDefaultBackupSet": true,
        "entityName": "string"
      }
    ],
    "task": {
      "taskType": "IMMEDIATE"
    },
    "subTasks": [
      {
        "subTask": {
          "subTaskType": "RESTORE",
          "operationType": "RESTORE"
        },
        "options": {
          "restoreOptions": {
            "browseOption": {
              "commCellId": 0,
              "backupset": {
                "clientName": "string",
                "backupsetName": "string"
              }
            },
            "destination": {
              "destClient": {
                "clientName": "string"
              },
              "destinationInstance": {
                "instanceName": "string",
                "applicationId": 125,
                "clientName": "string",
                "displayName": "string"
              }
            },
            "fileOption": {
              "sourceItem": [
                "string"
              ]
            },
            "postgresRstOption": {
              "tableLevelRestore": false,
              "refTime": {
                "time": 0
              },
              "fromTime": {
                "time": 0
              },
              "pointOfTime": {
                "time": 0
              },
              "pointInTime": false
            }
          },
          "commonOpts": {
            "notifyUserOnJobCompletion": true,
            "prePostOpts": {
              "preRecoveryCommand": "string",
              "postRecoveryCommand": "string",
              "runPostWhenFail": true
            }
          }
        }
      }
    ]
  }
}'