Configure Backup Client PostgreSQL Instance
Select
This API creates Cloud Database Instance for PostgreSQL.
All the databases in the PostgreSQL instance will be backed up after creation.
Use GET azuredb/postgresql/instance API to get the dbInstanceIdentifier and port.
- application/json
Request Body
- CreateInstance-SaaS
- CreateInstance-CustomerManaged
region object required
id integername stringcloudAccount object required
id integername string- dbInstanceIdentifier string required
Database name. Use Select Instance API to fetch this
- endPoint string required
Database endpoint or hostname
- port integer required
Database port
plan object required
id integername string- sslEnabled boolean
Default is false
- SSL_CA_Certificate string
database object required
Database connection credentials
username string requiredDB user name
password stringDB Password. Optional - Not needed if its AD User
backupGateways object[]
List of backupGateways or AccessNodes for Azure DB backup
Optional : Not required if the directCloudBackup is set to true
id integerBackup Gateway ID
name stringBackup Gateway Name
cloudAccount object required
id integername string- dbInstanceIdentifier string required
Database name. Use Select Instance API to fetch this
- endPoint string required
Database endpoint or hostname
- port integer required
Database port
plan object required
id integername string- sslEnabled boolean
Default is false
- SSL_CA_Certificate string
database object required
Database connection credentials
username string requiredDB user name
password stringDB Password. Optional - Not needed if its AD User
- 200
- 500
OK
- application/json
- Schema
- Example (from schema)
- Example 1
Schema
instance object
id integername string
{
"instance": {
"id": 0,
"name": "string"
}
}
{
"instance": {
"name": "pg11servereastus[eastus]",
"id": 1753
}
}
Internal Server Error
- application/json
- Schema
- Example (from schema)
- Example 1
Schema
- failedStage string
- errorCode integer
errorMessage object
errorMessage stringerrorCode stringentity object
subclientId stringclientId stringinstanceName stringinstanceId string_type_ string
{
"failedStage": "string",
"errorCode": 0,
"errorMessage": {
"errorMessage": "string",
"errorCode": "string",
"entity": {
"subclientId": "string",
"clientId": "string",
"instanceName": "string",
"instanceId": "string",
"_type_": "string"
}
}
}
{
"failedStage": "PostInstance",
"errorCode": -1,
"errorMessage": {
"errorMessage": "Unable to connect to client [] to execute [PostgreSQLBrowseAgent].\\\\nPlease ensure that all iDataAgent software is properly installed.\\\\nAlso check network connectivity and if this product's services are running.",
"errorCode": "4444",
"entity": {
"subclientId": "0",
"clientId": "2015",
"instanceName": "pg11servereastus[eastus]",
"instanceId": "1962",
"_type_": "ROOT_ENTITY"
}
}
}