Microsoft.DBforPostgreSQL (preview:2025-01-01)

2025/04/29 • 72 new methods

Administrators_Create (new)
Description Creates a new server.
Reference Link ¶

⚼ Request

PUT:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/administrators/{objectId}
{
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
objectId: string ,
api-version: string ,
parameters:
{
properties:
{
principalType: enum ,
principalName: string ,
tenantId: string ,
}
,
}
,
}

⚐ Response (200)

{
properties:
{
principalType: enum ,
principalName: string ,
objectId: string ,
tenantId: string ,
}
,
}

⚐ Response (201)

{
properties:
{
principalType: enum ,
principalName: string ,
objectId: string ,
tenantId: string ,
}
,
}

⚐ Response (202)

{
location: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Administrators_Delete (new)
Description Deletes an Microsoft Entra Administrator associated with the server.
Reference Link ¶

⚼ Request

DELETE:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/administrators/{objectId}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
objectId: string ,
}

⚐ Response (200)

{}

⚐ Response (202)

{
location: string ,
}

⚐ Response (204)

{}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Administrators_Get (new)
Description Gets information about a server.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/administrators/{objectId}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
objectId: string ,
}

⚐ Response (200)

{
properties:
{
principalType: enum ,
principalName: string ,
objectId: string ,
tenantId: string ,
}
,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Administrators_ListByServer (new)
Description List all the AAD administrators for a given server.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/administrators
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
}

⚐ Response (200)

{
value:
[
{
properties:
{
principalType: enum ,
principalName: string ,
objectId: string ,
tenantId: string ,
}
,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Backups_Create (new)
Description Create a specific backup for PostgreSQL flexible server.
Reference Link ¶

⚼ Request

PUT:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/backups/{backupName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
backupName: string ,
}

⚐ Response (200)

{
properties:
{
backupType: enum ,
completedTime: string ,
source: string ,
}
,
}

⚐ Response (201)

{
properties:
{
backupType: enum ,
completedTime: string ,
source: string ,
}
,
}

⚐ Response (202)

{
location: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Backups_Delete (new)
Description Deletes a specific backup.
Reference Link ¶

⚼ Request

DELETE:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/backups/{backupName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
backupName: string ,
}

⚐ Response (202)

{
location: string ,
}

⚐ Response (204)

{}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Backups_Get (new)
Description Get specific backup for a given server.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/backups/{backupName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
backupName: string ,
}

⚐ Response (200)

{
properties:
{
backupType: enum ,
completedTime: string ,
source: string ,
}
,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Backups_ListByServer (new)
Description List all the backups for a given server.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/backups
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
}

⚐ Response (200)

{
value:
[
{
properties:
{
backupType: enum ,
completedTime: string ,
source: string ,
}
,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
LocationBasedCapabilities_Execute (new)
Description Get capabilities at specified location in a given subscription.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/providers/Microsoft.DBforPostgreSQL/locations/{locationName}/capabilities
{
api-version: string ,
subscriptionId: string ,
locationName: string ,
}

⚐ Response (200)

{
value:
[
{
name: string ,
supportedServerEditions:
[
{
name: string ,
defaultSkuName: string ,
supportedStorageEditions:
[
{
name: string ,
defaultStorageSizeMb: integer ,
supportedStorageMb:
[
{
supportedIops: integer ,
supportedMaximumIops: integer ,
storageSizeMb: integer ,
maximumStorageSizeMb: integer ,
supportedThroughput: integer ,
supportedMaximumThroughput: integer ,
defaultIopsTier: string ,
supportedIopsTiers:
[
{
name: string ,
iops: integer ,
}
,
]
,
}
,
]
,
}
,
]
,
supportedServerSkus:
[
{
name: string ,
vCores: integer ,
supportedIops: integer ,
supportedMemoryPerVcoreMb: integer ,
supportedZones:
[
string ,
]
,
supportedHaMode:
[
string ,
]
,
supportedFeatures:
[
{
name: string ,
status: enum ,
}
,
]
,
securityProfile: string ,
}
,
]
,
}
,
]
,
supportedServerVersions:
[
{
name: string ,
supportedVersionsToUpgrade:
[
string ,
]
,
supportedFeatures:
[
{
name: string ,
status: enum ,
}
,
]
,
}
,
]
,
supportedFeatures:
[
{
name: string ,
status: enum ,
}
,
]
,
fastProvisioningSupported: enum ,
supportedFastProvisioningEditions:
[
{
supportedTier: string ,
supportedSku: string ,
supportedStorageGb: integer ,
supportedServerVersions: string ,
serverCount: integer ,
}
,
]
,
geoBackupSupported: enum ,
zoneRedundantHaSupported: enum ,
zoneRedundantHaAndGeoBackupSupported: enum ,
storageAutoGrowthSupported: enum ,
onlineResizeSupported: enum ,
restricted: enum ,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
ServerCapabilities_List (new)
Description Get capabilities for a flexible server.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/capabilities
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
}

⚐ Response (200)

{
value:
[
{
name: string ,
supportedServerEditions:
[
{
name: string ,
defaultSkuName: string ,
supportedStorageEditions:
[
{
name: string ,
defaultStorageSizeMb: integer ,
supportedStorageMb:
[
{
supportedIops: integer ,
supportedMaximumIops: integer ,
storageSizeMb: integer ,
maximumStorageSizeMb: integer ,
supportedThroughput: integer ,
supportedMaximumThroughput: integer ,
defaultIopsTier: string ,
supportedIopsTiers:
[
{
name: string ,
iops: integer ,
}
,
]
,
}
,
]
,
}
,
]
,
supportedServerSkus:
[
{
name: string ,
vCores: integer ,
supportedIops: integer ,
supportedMemoryPerVcoreMb: integer ,
supportedZones:
[
string ,
]
,
supportedHaMode:
[
string ,
]
,
supportedFeatures:
[
{
name: string ,
status: enum ,
}
,
]
,
securityProfile: string ,
}
,
]
,
}
,
]
,
supportedServerVersions:
[
{
name: string ,
supportedVersionsToUpgrade:
[
string ,
]
,
supportedFeatures:
[
{
name: string ,
status: enum ,
}
,
]
,
}
,
]
,
supportedFeatures:
[
{
name: string ,
status: enum ,
}
,
]
,
fastProvisioningSupported: enum ,
supportedFastProvisioningEditions:
[
{
supportedTier: string ,
supportedSku: string ,
supportedStorageGb: integer ,
supportedServerVersions: string ,
serverCount: integer ,
}
,
]
,
geoBackupSupported: enum ,
zoneRedundantHaSupported: enum ,
zoneRedundantHaAndGeoBackupSupported: enum ,
storageAutoGrowthSupported: enum ,
onlineResizeSupported: enum ,
restricted: enum ,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
CheckNameAvailability_Execute (new)
Description Check the availability of name for resource
Reference Link ¶

⚼ Request

POST:  /subscriptions/{subscriptionId}/providers/Microsoft.DBforPostgreSQL/checkNameAvailability
{
api-version: string ,
subscriptionId: string ,
nameAvailabilityRequest:
{
name: string ,
type: string ,
}
,
}

⚐ Response (200)

{
name: string ,
type: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
CheckNameAvailabilityWithLocation_Execute (new)
Description Check the availability of name for resource
Reference Link ¶

⚼ Request

POST:  /subscriptions/{subscriptionId}/providers/Microsoft.DBforPostgreSQL/locations/{locationName}/checkNameAvailability
{
api-version: string ,
subscriptionId: string ,
locationName: string ,
nameAvailabilityRequest:
{
name: string ,
type: string ,
}
,
}

⚐ Response (200)

{
name: string ,
type: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Configurations_ListByServer (new)
Description List all the configurations in a given server.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/configurations
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
}

⚐ Response (200)

{
value:
[
{
properties:
{
value: string ,
description: string ,
defaultValue: string ,
dataType: enum ,
allowedValues: string ,
source: string ,
isDynamicConfig: boolean ,
isReadOnly: boolean ,
isConfigPendingRestart: boolean ,
unit: string ,
documentationLink: string ,
}
,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Configurations_Get (new)
Description Gets information about a configuration of server.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/configurations/{configurationName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
configurationName: string ,
}

⚐ Response (200)

{
properties:
{
value: string ,
description: string ,
defaultValue: string ,
dataType: enum ,
allowedValues: string ,
source: string ,
isDynamicConfig: boolean ,
isReadOnly: boolean ,
isConfigPendingRestart: boolean ,
unit: string ,
documentationLink: string ,
}
,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Configurations_Update (new)
Description Updates a configuration of a server.
Reference Link ¶

⚼ Request

PATCH:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/configurations/{configurationName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
configurationName: string ,
parameters:
{
properties:
{
value: string ,
description: string ,
defaultValue: string ,
dataType: enum ,
allowedValues: string ,
source: string ,
isDynamicConfig: boolean ,
isReadOnly: boolean ,
isConfigPendingRestart: boolean ,
unit: string ,
documentationLink: string ,
}
,
}
,
}

⚐ Response (200)

{
properties:
{
value: string ,
description: string ,
defaultValue: string ,
dataType: enum ,
allowedValues: string ,
source: string ,
isDynamicConfig: boolean ,
isReadOnly: boolean ,
isConfigPendingRestart: boolean ,
unit: string ,
documentationLink: string ,
}
,
}

⚐ Response (201)

{
properties:
{
value: string ,
description: string ,
defaultValue: string ,
dataType: enum ,
allowedValues: string ,
source: string ,
isDynamicConfig: boolean ,
isReadOnly: boolean ,
isConfigPendingRestart: boolean ,
unit: string ,
documentationLink: string ,
}
,
}

⚐ Response (202)

{
location: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Configurations_Put (new)
Description Updates a configuration of a server.
Reference Link ¶

⚼ Request

PUT:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/configurations/{configurationName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
configurationName: string ,
parameters:
{
properties:
{
value: string ,
description: string ,
defaultValue: string ,
dataType: enum ,
allowedValues: string ,
source: string ,
isDynamicConfig: boolean ,
isReadOnly: boolean ,
isConfigPendingRestart: boolean ,
unit: string ,
documentationLink: string ,
}
,
}
,
}

⚐ Response (200)

{
properties:
{
value: string ,
description: string ,
defaultValue: string ,
dataType: enum ,
allowedValues: string ,
source: string ,
isDynamicConfig: boolean ,
isReadOnly: boolean ,
isConfigPendingRestart: boolean ,
unit: string ,
documentationLink: string ,
}
,
}

⚐ Response (201)

{
properties:
{
value: string ,
description: string ,
defaultValue: string ,
dataType: enum ,
allowedValues: string ,
source: string ,
isDynamicConfig: boolean ,
isReadOnly: boolean ,
isConfigPendingRestart: boolean ,
unit: string ,
documentationLink: string ,
}
,
}

⚐ Response (202)

{
location: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Databases_Create (new)
Description Creates a new database or updates an existing database.
Reference Link ¶

⚼ Request

PUT:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/databases/{databaseName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
databaseName: string ,
parameters:
{
properties:
{
charset: string ,
collation: string ,
}
,
}
,
}

⚐ Response (200)

{
properties:
{
charset: string ,
collation: string ,
}
,
}

⚐ Response (201)

{
properties:
{
charset: string ,
collation: string ,
}
,
}

⚐ Response (202)

{
location: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Databases_Delete (new)
Description Deletes a database.
Reference Link ¶

⚼ Request

DELETE:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/databases/{databaseName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
databaseName: string ,
}

⚐ Response (200)

{}

⚐ Response (202)

{
location: string ,
}

⚐ Response (204)

{}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Databases_Get (new)
Description Gets information about a database.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/databases/{databaseName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
databaseName: string ,
}

⚐ Response (200)

{
properties:
{
charset: string ,
collation: string ,
}
,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Databases_ListByServer (new)
Description List all the databases in a given server.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/databases
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
}

⚐ Response (200)

{
value:
[
{
properties:
{
charset: string ,
collation: string ,
}
,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
FirewallRules_CreateOrUpdate (new)
Description Creates a new firewall rule or updates an existing firewall rule.
Reference Link ¶

⚼ Request

PUT:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/firewallRules/{firewallRuleName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
firewallRuleName: string ,
parameters:
{
properties:
{
startIpAddress: string ,
endIpAddress: string ,
}
,
}
,
}

⚐ Response (200)

{
properties:
{
startIpAddress: string ,
endIpAddress: string ,
}
,
}

⚐ Response (201)

{
properties:
{
startIpAddress: string ,
endIpAddress: string ,
}
,
}

⚐ Response (202)

{
location: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
FirewallRules_Delete (new)
Description Deletes a PostgreSQL server firewall rule.
Reference Link ¶

⚼ Request

DELETE:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/firewallRules/{firewallRuleName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
firewallRuleName: string ,
}

⚐ Response (200)

{}

⚐ Response (202)

{
location: string ,
}

⚐ Response (204)

{}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
FirewallRules_Get (new)
Description List all the firewall rules in a given server.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/firewallRules/{firewallRuleName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
firewallRuleName: string ,
}

⚐ Response (200)

{
properties:
{
startIpAddress: string ,
endIpAddress: string ,
}
,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
FirewallRules_ListByServer (new)
Description List all the firewall rules in a given PostgreSQL server.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/firewallRules
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
}

⚐ Response (200)

{
value:
[
{
properties:
{
startIpAddress: string ,
endIpAddress: string ,
}
,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Servers_Create (new)
Description Creates a new server.
Reference Link ¶

⚼ Request

PUT:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
parameters:
{
sku:
{
name: string ,
tier: enum ,
}
,
identity:
{
userAssignedIdentities: object ,
principalId: string ,
type: enum ,
tenantId: string ,
}
,
properties:
{
administratorLogin: string ,
administratorLoginPassword: string ,
version: enum ,
minorVersion: string ,
state: enum ,
fullyQualifiedDomainName: string ,
storage:
{
storageSizeGB: integer ,
autoGrow: enum ,
tier: enum ,
iops: integer ,
throughput: integer ,
type: enum ,
}
,
authConfig:
{
activeDirectoryAuth: enum ,
passwordAuth: enum ,
tenantId: string ,
}
,
dataEncryption:
{
primaryKeyURI: string ,
primaryUserAssignedIdentityId: string ,
geoBackupKeyURI: string ,
geoBackupUserAssignedIdentityId: string ,
type: enum ,
primaryEncryptionKeyStatus: enum ,
geoBackupEncryptionKeyStatus: enum ,
}
,
backup:
{
backupRetentionDays: integer ,
geoRedundantBackup: enum ,
earliestRestoreDate: string ,
}
,
network:
{
publicNetworkAccess: enum ,
delegatedSubnetResourceId: string ,
privateDnsZoneArmResourceId: string ,
}
,
highAvailability:
{
mode: enum ,
state: enum ,
standbyAvailabilityZone: string ,
}
,
maintenanceWindow:
{
customWindow: string ,
startHour: integer ,
startMinute: integer ,
dayOfWeek: integer ,
}
,
sourceServerResourceId: string ,
pointInTimeUTC: string ,
availabilityZone: string ,
replicationRole: enum ,
replicaCapacity: integer ,
replica:
{
role: enum ,
capacity: integer ,
replicationState: enum ,
promoteMode: enum ,
promoteOption: enum ,
}
,
createMode: enum ,
privateEndpointConnections:
[
{
properties:
{
groupIds:
[
string ,
]
,
privateEndpoint:
{
id: string ,
}
,
privateLinkServiceConnectionState:
{
status: enum ,
description: string ,
actionsRequired: string ,
}
,
provisioningState: enum ,
}
,
}
,
]
,
cluster:
{
clusterSize: integer ,
}
,
}
,
}
,
}

⚐ Response (200)

{
sku:
{
name: string ,
tier: enum ,
}
,
identity:
{
userAssignedIdentities: object ,
principalId: string ,
type: enum ,
tenantId: string ,
}
,
properties:
{
administratorLogin: string ,
administratorLoginPassword: string ,
version: enum ,
minorVersion: string ,
state: enum ,
fullyQualifiedDomainName: string ,
storage:
{
storageSizeGB: integer ,
autoGrow: enum ,
tier: enum ,
iops: integer ,
throughput: integer ,
type: enum ,
}
,
authConfig:
{
activeDirectoryAuth: enum ,
passwordAuth: enum ,
tenantId: string ,
}
,
dataEncryption:
{
primaryKeyURI: string ,
primaryUserAssignedIdentityId: string ,
geoBackupKeyURI: string ,
geoBackupUserAssignedIdentityId: string ,
type: enum ,
primaryEncryptionKeyStatus: enum ,
geoBackupEncryptionKeyStatus: enum ,
}
,
backup:
{
backupRetentionDays: integer ,
geoRedundantBackup: enum ,
earliestRestoreDate: string ,
}
,
network:
{
publicNetworkAccess: enum ,
delegatedSubnetResourceId: string ,
privateDnsZoneArmResourceId: string ,
}
,
highAvailability:
{
mode: enum ,
state: enum ,
standbyAvailabilityZone: string ,
}
,
maintenanceWindow:
{
customWindow: string ,
startHour: integer ,
startMinute: integer ,
dayOfWeek: integer ,
}
,
sourceServerResourceId: string ,
pointInTimeUTC: string ,
availabilityZone: string ,
replicationRole: enum ,
replicaCapacity: integer ,
replica:
{
role: enum ,
capacity: integer ,
replicationState: enum ,
promoteMode: enum ,
promoteOption: enum ,
}
,
createMode: enum ,
privateEndpointConnections:
[
{
properties:
{
groupIds:
[
string ,
]
,
privateEndpoint:
{
id: string ,
}
,
privateLinkServiceConnectionState:
{
status: enum ,
description: string ,
actionsRequired: string ,
}
,
provisioningState: enum ,
}
,
}
,
]
,
cluster:
{
clusterSize: integer ,
}
,
}
,
}

⚐ Response (201)

{
sku:
{
name: string ,
tier: enum ,
}
,
identity:
{
userAssignedIdentities: object ,
principalId: string ,
type: enum ,
tenantId: string ,
}
,
properties:
{
administratorLogin: string ,
administratorLoginPassword: string ,
version: enum ,
minorVersion: string ,
state: enum ,
fullyQualifiedDomainName: string ,
storage:
{
storageSizeGB: integer ,
autoGrow: enum ,
tier: enum ,
iops: integer ,
throughput: integer ,
type: enum ,
}
,
authConfig:
{
activeDirectoryAuth: enum ,
passwordAuth: enum ,
tenantId: string ,
}
,
dataEncryption:
{
primaryKeyURI: string ,
primaryUserAssignedIdentityId: string ,
geoBackupKeyURI: string ,
geoBackupUserAssignedIdentityId: string ,
type: enum ,
primaryEncryptionKeyStatus: enum ,
geoBackupEncryptionKeyStatus: enum ,
}
,
backup:
{
backupRetentionDays: integer ,
geoRedundantBackup: enum ,
earliestRestoreDate: string ,
}
,
network:
{
publicNetworkAccess: enum ,
delegatedSubnetResourceId: string ,
privateDnsZoneArmResourceId: string ,
}
,
highAvailability:
{
mode: enum ,
state: enum ,
standbyAvailabilityZone: string ,
}
,
maintenanceWindow:
{
customWindow: string ,
startHour: integer ,
startMinute: integer ,
dayOfWeek: integer ,
}
,
sourceServerResourceId: string ,
pointInTimeUTC: string ,
availabilityZone: string ,
replicationRole: enum ,
replicaCapacity: integer ,
replica:
{
role: enum ,
capacity: integer ,
replicationState: enum ,
promoteMode: enum ,
promoteOption: enum ,
}
,
createMode: enum ,
privateEndpointConnections:
[
{
properties:
{
groupIds:
[
string ,
]
,
privateEndpoint:
{
id: string ,
}
,
privateLinkServiceConnectionState:
{
status: enum ,
description: string ,
actionsRequired: string ,
}
,
provisioningState: enum ,
}
,
}
,
]
,
cluster:
{
clusterSize: integer ,
}
,
}
,
}

⚐ Response (202)

{
location: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Servers_Update (new)
Description Updates an existing server. The request body can contain one to many of the properties present in the normal server definition.
Reference Link ¶

⚼ Request

PATCH:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
parameters:
{
sku:
{
name: string ,
tier: enum ,
}
,
identity:
{
userAssignedIdentities: object ,
principalId: string ,
type: enum ,
tenantId: string ,
}
,
properties:
{
administratorLogin: string ,
administratorLoginPassword: string ,
version: enum ,
storage:
{
storageSizeGB: integer ,
autoGrow: enum ,
tier: enum ,
iops: integer ,
throughput: integer ,
type: enum ,
}
,
backup:
{
backupRetentionDays: integer ,
geoRedundantBackup: enum ,
earliestRestoreDate: string ,
}
,
highAvailability:
{
mode: enum ,
state: enum ,
standbyAvailabilityZone: string ,
}
,
maintenanceWindow:
{
customWindow: string ,
startHour: integer ,
startMinute: integer ,
dayOfWeek: integer ,
}
,
authConfig:
{
activeDirectoryAuth: enum ,
passwordAuth: enum ,
tenantId: string ,
}
,
dataEncryption:
{
primaryKeyURI: string ,
primaryUserAssignedIdentityId: string ,
geoBackupKeyURI: string ,
geoBackupUserAssignedIdentityId: string ,
type: enum ,
primaryEncryptionKeyStatus: enum ,
geoBackupEncryptionKeyStatus: enum ,
}
,
createMode: enum ,
replicationRole: enum ,
replica:
{
role: enum ,
capacity: integer ,
replicationState: enum ,
promoteMode: enum ,
promoteOption: enum ,
}
,
network:
{
publicNetworkAccess: enum ,
delegatedSubnetResourceId: string ,
privateDnsZoneArmResourceId: string ,
}
,
cluster:
{
clusterSize: integer ,
}
,
}
,
tags: object ,
}
,
}

⚐ Response (200)

{
sku:
{
name: string ,
tier: enum ,
}
,
identity:
{
userAssignedIdentities: object ,
principalId: string ,
type: enum ,
tenantId: string ,
}
,
properties:
{
administratorLogin: string ,
administratorLoginPassword: string ,
version: enum ,
minorVersion: string ,
state: enum ,
fullyQualifiedDomainName: string ,
storage:
{
storageSizeGB: integer ,
autoGrow: enum ,
tier: enum ,
iops: integer ,
throughput: integer ,
type: enum ,
}
,
authConfig:
{
activeDirectoryAuth: enum ,
passwordAuth: enum ,
tenantId: string ,
}
,
dataEncryption:
{
primaryKeyURI: string ,
primaryUserAssignedIdentityId: string ,
geoBackupKeyURI: string ,
geoBackupUserAssignedIdentityId: string ,
type: enum ,
primaryEncryptionKeyStatus: enum ,
geoBackupEncryptionKeyStatus: enum ,
}
,
backup:
{
backupRetentionDays: integer ,
geoRedundantBackup: enum ,
earliestRestoreDate: string ,
}
,
network:
{
publicNetworkAccess: enum ,
delegatedSubnetResourceId: string ,
privateDnsZoneArmResourceId: string ,
}
,
highAvailability:
{
mode: enum ,
state: enum ,
standbyAvailabilityZone: string ,
}
,
maintenanceWindow:
{
customWindow: string ,
startHour: integer ,
startMinute: integer ,
dayOfWeek: integer ,
}
,
sourceServerResourceId: string ,
pointInTimeUTC: string ,
availabilityZone: string ,
replicationRole: enum ,
replicaCapacity: integer ,
replica:
{
role: enum ,
capacity: integer ,
replicationState: enum ,
promoteMode: enum ,
promoteOption: enum ,
}
,
createMode: enum ,
privateEndpointConnections:
[
{
properties:
{
groupIds:
[
string ,
]
,
privateEndpoint:
{
id: string ,
}
,
privateLinkServiceConnectionState:
{
status: enum ,
description: string ,
actionsRequired: string ,
}
,
provisioningState: enum ,
}
,
}
,
]
,
cluster:
{
clusterSize: integer ,
}
,
}
,
}

⚐ Response (202)

{
location: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Servers_Delete (new)
Description Deletes a server.
Reference Link ¶

⚼ Request

DELETE:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
}

⚐ Response (200)

{}

⚐ Response (202)

{
location: string ,
}

⚐ Response (204)

{}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Servers_Get (new)
Description Gets information about a server.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
}

⚐ Response (200)

{
sku:
{
name: string ,
tier: enum ,
}
,
identity:
{
userAssignedIdentities: object ,
principalId: string ,
type: enum ,
tenantId: string ,
}
,
properties:
{
administratorLogin: string ,
administratorLoginPassword: string ,
version: enum ,
minorVersion: string ,
state: enum ,
fullyQualifiedDomainName: string ,
storage:
{
storageSizeGB: integer ,
autoGrow: enum ,
tier: enum ,
iops: integer ,
throughput: integer ,
type: enum ,
}
,
authConfig:
{
activeDirectoryAuth: enum ,
passwordAuth: enum ,
tenantId: string ,
}
,
dataEncryption:
{
primaryKeyURI: string ,
primaryUserAssignedIdentityId: string ,
geoBackupKeyURI: string ,
geoBackupUserAssignedIdentityId: string ,
type: enum ,
primaryEncryptionKeyStatus: enum ,
geoBackupEncryptionKeyStatus: enum ,
}
,
backup:
{
backupRetentionDays: integer ,
geoRedundantBackup: enum ,
earliestRestoreDate: string ,
}
,
network:
{
publicNetworkAccess: enum ,
delegatedSubnetResourceId: string ,
privateDnsZoneArmResourceId: string ,
}
,
highAvailability:
{
mode: enum ,
state: enum ,
standbyAvailabilityZone: string ,
}
,
maintenanceWindow:
{
customWindow: string ,
startHour: integer ,
startMinute: integer ,
dayOfWeek: integer ,
}
,
sourceServerResourceId: string ,
pointInTimeUTC: string ,
availabilityZone: string ,
replicationRole: enum ,
replicaCapacity: integer ,
replica:
{
role: enum ,
capacity: integer ,
replicationState: enum ,
promoteMode: enum ,
promoteOption: enum ,
}
,
createMode: enum ,
privateEndpointConnections:
[
{
properties:
{
groupIds:
[
string ,
]
,
privateEndpoint:
{
id: string ,
}
,
privateLinkServiceConnectionState:
{
status: enum ,
description: string ,
actionsRequired: string ,
}
,
provisioningState: enum ,
}
,
}
,
]
,
cluster:
{
clusterSize: integer ,
}
,
}
,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Servers_ListByResourceGroup (new)
Description List all the servers in a given resource group.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
}

⚐ Response (200)

{
value:
[
{
sku:
{
name: string ,
tier: enum ,
}
,
identity:
{
userAssignedIdentities: object ,
principalId: string ,
type: enum ,
tenantId: string ,
}
,
properties:
{
administratorLogin: string ,
administratorLoginPassword: string ,
version: enum ,
minorVersion: string ,
state: enum ,
fullyQualifiedDomainName: string ,
storage:
{
storageSizeGB: integer ,
autoGrow: enum ,
tier: enum ,
iops: integer ,
throughput: integer ,
type: enum ,
}
,
authConfig:
{
activeDirectoryAuth: enum ,
passwordAuth: enum ,
tenantId: string ,
}
,
dataEncryption:
{
primaryKeyURI: string ,
primaryUserAssignedIdentityId: string ,
geoBackupKeyURI: string ,
geoBackupUserAssignedIdentityId: string ,
type: enum ,
primaryEncryptionKeyStatus: enum ,
geoBackupEncryptionKeyStatus: enum ,
}
,
backup:
{
backupRetentionDays: integer ,
geoRedundantBackup: enum ,
earliestRestoreDate: string ,
}
,
network:
{
publicNetworkAccess: enum ,
delegatedSubnetResourceId: string ,
privateDnsZoneArmResourceId: string ,
}
,
highAvailability:
{
mode: enum ,
state: enum ,
standbyAvailabilityZone: string ,
}
,
maintenanceWindow:
{
customWindow: string ,
startHour: integer ,
startMinute: integer ,
dayOfWeek: integer ,
}
,
sourceServerResourceId: string ,
pointInTimeUTC: string ,
availabilityZone: string ,
replicationRole: enum ,
replicaCapacity: integer ,
replica:
{
role: enum ,
capacity: integer ,
replicationState: enum ,
promoteMode: enum ,
promoteOption: enum ,
}
,
createMode: enum ,
privateEndpointConnections:
[
{
properties:
{
groupIds:
[
string ,
]
,
privateEndpoint:
{
id: string ,
}
,
privateLinkServiceConnectionState:
{
status: enum ,
description: string ,
actionsRequired: string ,
}
,
provisioningState: enum ,
}
,
}
,
]
,
cluster:
{
clusterSize: integer ,
}
,
}
,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Servers_List (new)
Description List all the servers in a given subscription.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/providers/Microsoft.DBforPostgreSQL/flexibleServers
{
api-version: string ,
subscriptionId: string ,
}

⚐ Response (200)

{
value:
[
{
sku:
{
name: string ,
tier: enum ,
}
,
identity:
{
userAssignedIdentities: object ,
principalId: string ,
type: enum ,
tenantId: string ,
}
,
properties:
{
administratorLogin: string ,
administratorLoginPassword: string ,
version: enum ,
minorVersion: string ,
state: enum ,
fullyQualifiedDomainName: string ,
storage:
{
storageSizeGB: integer ,
autoGrow: enum ,
tier: enum ,
iops: integer ,
throughput: integer ,
type: enum ,
}
,
authConfig:
{
activeDirectoryAuth: enum ,
passwordAuth: enum ,
tenantId: string ,
}
,
dataEncryption:
{
primaryKeyURI: string ,
primaryUserAssignedIdentityId: string ,
geoBackupKeyURI: string ,
geoBackupUserAssignedIdentityId: string ,
type: enum ,
primaryEncryptionKeyStatus: enum ,
geoBackupEncryptionKeyStatus: enum ,
}
,
backup:
{
backupRetentionDays: integer ,
geoRedundantBackup: enum ,
earliestRestoreDate: string ,
}
,
network:
{
publicNetworkAccess: enum ,
delegatedSubnetResourceId: string ,
privateDnsZoneArmResourceId: string ,
}
,
highAvailability:
{
mode: enum ,
state: enum ,
standbyAvailabilityZone: string ,
}
,
maintenanceWindow:
{
customWindow: string ,
startHour: integer ,
startMinute: integer ,
dayOfWeek: integer ,
}
,
sourceServerResourceId: string ,
pointInTimeUTC: string ,
availabilityZone: string ,
replicationRole: enum ,
replicaCapacity: integer ,
replica:
{
role: enum ,
capacity: integer ,
replicationState: enum ,
promoteMode: enum ,
promoteOption: enum ,
}
,
createMode: enum ,
privateEndpointConnections:
[
{
properties:
{
groupIds:
[
string ,
]
,
privateEndpoint:
{
id: string ,
}
,
privateLinkServiceConnectionState:
{
status: enum ,
description: string ,
actionsRequired: string ,
}
,
provisioningState: enum ,
}
,
}
,
]
,
cluster:
{
clusterSize: integer ,
}
,
}
,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
FlexibleServer_TriggerLtrPreBackup (new)
Description PreBackup operation performs all the checks that are needed for the subsequent long term retention backup operation to succeed.
Reference Link ¶

⚼ Request

POST:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/ltrPreBackup
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
parameters: object ,
}

⚐ Response (200)

{
$headers:
{
x-ms-request-id: string ,
}
,
$schema:
{
properties:
{
numberOfContainers: integer ,
}
,
}
,
}

⚐ Response (default)

{
$headers:
{
x-ms-error-code: string ,
x-ms-request-id: string ,
}
,
$schema:
{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
,
}
FlexibleServer_StartLtrBackup (new)
Description Start the Long Term Retention Backup operation
Reference Link ¶

⚼ Request

POST:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/startLtrBackup
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
parameters:
{
targetDetails:
{
sasUriList:
[
string ,
]
,
}
,
}
,
}

⚐ Response (200)

{
$headers:
{
x-ms-request-id: string ,
}
,
$schema:
{
properties:
{
datasourceSizeInBytes: integer ,
dataTransferredInBytes: integer ,
backupName: string ,
backupMetadata: string ,
status: enum ,
startTime: string ,
endTime: string ,
percentComplete: number ,
errorCode: string ,
errorMessage: string ,
}
,
}
,
}

⚐ Response (202)

{
retry-after: integer ,
x-ms-request-id: string ,
location: string ,
azure-asyncoperation: string ,
}

⚐ Response (default)

{
$headers:
{
x-ms-error-code: string ,
x-ms-request-id: string ,
}
,
$schema:
{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
,
}
ltrBackupOperations_Get (new)
Description Gets the result of the give long term retention backup operation for the flexible server.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/ltrBackupOperations/{backupName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
backupName: string ,
}

⚐ Response (200)

{
properties:
{
datasourceSizeInBytes: integer ,
dataTransferredInBytes: integer ,
backupName: string ,
backupMetadata: string ,
status: enum ,
startTime: string ,
endTime: string ,
percentComplete: number ,
errorCode: string ,
errorMessage: string ,
}
,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
ltrBackupOperations_ListByServer (new)
Description Gets the result of the give long term retention backup operations for the flexible server.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/ltrBackupOperations
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
}

⚐ Response (200)

{
value:
[
{
properties:
{
datasourceSizeInBytes: integer ,
dataTransferredInBytes: integer ,
backupName: string ,
backupMetadata: string ,
status: enum ,
startTime: string ,
endTime: string ,
percentComplete: number ,
errorCode: string ,
errorMessage: string ,
}
,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Migrations_Create (new)
Description Creates a new migration.
Reference Link ¶

⚼ Request

PUT:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{targetDbServerName}/migrations/{migrationName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
targetDbServerName: string ,
migrationName: string ,
parameters:
{
properties:
{
migrationId: string ,
currentStatus:
{
state: enum ,
error: string ,
currentSubStateDetails:
{
currentSubState: enum ,
dbDetails: object ,
validationDetails:
{
status: enum ,
validationStartTimeInUtc: string ,
validationEndTimeInUtc: string ,
serverLevelValidationDetails:
[
{
type: string ,
state: enum ,
messages:
[
{
state: enum ,
message: string ,
}
,
]
,
}
,
]
,
dbLevelValidationDetails:
[
{
databaseName: string ,
startedOn: string ,
endedOn: string ,
summary:
[
{
type: string ,
state: enum ,
messages:
[
{
state: enum ,
message: string ,
}
,
]
,
}
,
]
,
}
,
]
,
}
,
}
,
}
,
migrationInstanceResourceId: string ,
migrationMode: enum ,
migrationOption: enum ,
sourceType: enum ,
sslMode: enum ,
sourceDbServerMetadata:
{
location: string ,
version: string ,
storageMb: integer ,
sku:
{
name: string ,
tier: enum ,
}
,
}
,
targetDbServerMetadata:
{
location: string ,
version: string ,
storageMb: integer ,
sku:
{
name: string ,
tier: enum ,
}
,
}
,
sourceDbServerResourceId: string ,
sourceDbServerFullyQualifiedDomainName: string ,
targetDbServerResourceId: string ,
targetDbServerFullyQualifiedDomainName: string ,
secretParameters:
{
adminCredentials:
{
sourceServerPassword: string ,
targetServerPassword: string ,
}
,
sourceServerUsername: string ,
targetServerUsername: string ,
}
,
dbsToMigrate:
[
string ,
]
,
setupLogicalReplicationOnSourceDbIfNeeded: enum ,
overwriteDbsInTarget: enum ,
migrationWindowStartTimeInUtc: string ,
migrationWindowEndTimeInUtc: string ,
migrateRoles: enum ,
startDataMigration: enum ,
triggerCutover: enum ,
dbsToTriggerCutoverOn:
[
string ,
]
,
cancel: enum ,
dbsToCancelMigrationOn:
[
string ,
]
,
}
,
}
,
}

⚐ Response (200)

{
properties:
{
migrationId: string ,
currentStatus:
{
state: enum ,
error: string ,
currentSubStateDetails:
{
currentSubState: enum ,
dbDetails: object ,
validationDetails:
{
status: enum ,
validationStartTimeInUtc: string ,
validationEndTimeInUtc: string ,
serverLevelValidationDetails:
[
{
type: string ,
state: enum ,
messages:
[
{
state: enum ,
message: string ,
}
,
]
,
}
,
]
,
dbLevelValidationDetails:
[
{
databaseName: string ,
startedOn: string ,
endedOn: string ,
summary:
[
{
type: string ,
state: enum ,
messages:
[
{
state: enum ,
message: string ,
}
,
]
,
}
,
]
,
}
,
]
,
}
,
}
,
}
,
migrationInstanceResourceId: string ,
migrationMode: enum ,
migrationOption: enum ,
sourceType: enum ,
sslMode: enum ,
sourceDbServerMetadata:
{
location: string ,
version: string ,
storageMb: integer ,
sku:
{
name: string ,
tier: enum ,
}
,
}
,
targetDbServerMetadata:
{
location: string ,
version: string ,
storageMb: integer ,
sku:
{
name: string ,
tier: enum ,
}
,
}
,
sourceDbServerResourceId: string ,
sourceDbServerFullyQualifiedDomainName: string ,
targetDbServerResourceId: string ,
targetDbServerFullyQualifiedDomainName: string ,
secretParameters:
{
adminCredentials:
{
sourceServerPassword: string ,
targetServerPassword: string ,
}
,
sourceServerUsername: string ,
targetServerUsername: string ,
}
,
dbsToMigrate:
[
string ,
]
,
setupLogicalReplicationOnSourceDbIfNeeded: enum ,
overwriteDbsInTarget: enum ,
migrationWindowStartTimeInUtc: string ,
migrationWindowEndTimeInUtc: string ,
migrateRoles: enum ,
startDataMigration: enum ,
triggerCutover: enum ,
dbsToTriggerCutoverOn:
[
string ,
]
,
cancel: enum ,
dbsToCancelMigrationOn:
[
string ,
]
,
}
,
}

⚐ Response (201)

{
properties:
{
migrationId: string ,
currentStatus:
{
state: enum ,
error: string ,
currentSubStateDetails:
{
currentSubState: enum ,
dbDetails: object ,
validationDetails:
{
status: enum ,
validationStartTimeInUtc: string ,
validationEndTimeInUtc: string ,
serverLevelValidationDetails:
[
{
type: string ,
state: enum ,
messages:
[
{
state: enum ,
message: string ,
}
,
]
,
}
,
]
,
dbLevelValidationDetails:
[
{
databaseName: string ,
startedOn: string ,
endedOn: string ,
summary:
[
{
type: string ,
state: enum ,
messages:
[
{
state: enum ,
message: string ,
}
,
]
,
}
,
]
,
}
,
]
,
}
,
}
,
}
,
migrationInstanceResourceId: string ,
migrationMode: enum ,
migrationOption: enum ,
sourceType: enum ,
sslMode: enum ,
sourceDbServerMetadata:
{
location: string ,
version: string ,
storageMb: integer ,
sku:
{
name: string ,
tier: enum ,
}
,
}
,
targetDbServerMetadata:
{
location: string ,
version: string ,
storageMb: integer ,
sku:
{
name: string ,
tier: enum ,
}
,
}
,
sourceDbServerResourceId: string ,
sourceDbServerFullyQualifiedDomainName: string ,
targetDbServerResourceId: string ,
targetDbServerFullyQualifiedDomainName: string ,
secretParameters:
{
adminCredentials:
{
sourceServerPassword: string ,
targetServerPassword: string ,
}
,
sourceServerUsername: string ,
targetServerUsername: string ,
}
,
dbsToMigrate:
[
string ,
]
,
setupLogicalReplicationOnSourceDbIfNeeded: enum ,
overwriteDbsInTarget: enum ,
migrationWindowStartTimeInUtc: string ,
migrationWindowEndTimeInUtc: string ,
migrateRoles: enum ,
startDataMigration: enum ,
triggerCutover: enum ,
dbsToTriggerCutoverOn:
[
string ,
]
,
cancel: enum ,
dbsToCancelMigrationOn:
[
string ,
]
,
}
,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Migrations_Get (new)
Description Gets details of a migration.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{targetDbServerName}/migrations/{migrationName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
targetDbServerName: string ,
migrationName: string ,
}

⚐ Response (200)

{
properties:
{
migrationId: string ,
currentStatus:
{
state: enum ,
error: string ,
currentSubStateDetails:
{
currentSubState: enum ,
dbDetails: object ,
validationDetails:
{
status: enum ,
validationStartTimeInUtc: string ,
validationEndTimeInUtc: string ,
serverLevelValidationDetails:
[
{
type: string ,
state: enum ,
messages:
[
{
state: enum ,
message: string ,
}
,
]
,
}
,
]
,
dbLevelValidationDetails:
[
{
databaseName: string ,
startedOn: string ,
endedOn: string ,
summary:
[
{
type: string ,
state: enum ,
messages:
[
{
state: enum ,
message: string ,
}
,
]
,
}
,
]
,
}
,
]
,
}
,
}
,
}
,
migrationInstanceResourceId: string ,
migrationMode: enum ,
migrationOption: enum ,
sourceType: enum ,
sslMode: enum ,
sourceDbServerMetadata:
{
location: string ,
version: string ,
storageMb: integer ,
sku:
{
name: string ,
tier: enum ,
}
,
}
,
targetDbServerMetadata:
{
location: string ,
version: string ,
storageMb: integer ,
sku:
{
name: string ,
tier: enum ,
}
,
}
,
sourceDbServerResourceId: string ,
sourceDbServerFullyQualifiedDomainName: string ,
targetDbServerResourceId: string ,
targetDbServerFullyQualifiedDomainName: string ,
secretParameters:
{
adminCredentials:
{
sourceServerPassword: string ,
targetServerPassword: string ,
}
,
sourceServerUsername: string ,
targetServerUsername: string ,
}
,
dbsToMigrate:
[
string ,
]
,
setupLogicalReplicationOnSourceDbIfNeeded: enum ,
overwriteDbsInTarget: enum ,
migrationWindowStartTimeInUtc: string ,
migrationWindowEndTimeInUtc: string ,
migrateRoles: enum ,
startDataMigration: enum ,
triggerCutover: enum ,
dbsToTriggerCutoverOn:
[
string ,
]
,
cancel: enum ,
dbsToCancelMigrationOn:
[
string ,
]
,
}
,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Migrations_Update (new)
Description Updates an existing migration. The request body can contain one to many of the mutable properties present in the migration definition. Certain property updates initiate migration state transitions.
Reference Link ¶

⚼ Request

PATCH:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{targetDbServerName}/migrations/{migrationName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
targetDbServerName: string ,
migrationName: string ,
parameters:
{
properties:
{
sourceDbServerResourceId: string ,
sourceDbServerFullyQualifiedDomainName: string ,
targetDbServerFullyQualifiedDomainName: string ,
secretParameters:
{
adminCredentials:
{
sourceServerPassword: string ,
targetServerPassword: string ,
}
,
sourceServerUsername: string ,
targetServerUsername: string ,
}
,
dbsToMigrate:
[
string ,
]
,
setupLogicalReplicationOnSourceDbIfNeeded: enum ,
overwriteDbsInTarget: enum ,
migrationWindowStartTimeInUtc: string ,
migrateRoles: enum ,
startDataMigration: enum ,
triggerCutover: enum ,
dbsToTriggerCutoverOn:
[
string ,
]
,
cancel: enum ,
dbsToCancelMigrationOn:
[
string ,
]
,
migrationMode: enum ,
}
,
tags: object ,
}
,
}

⚐ Response (200)

{
properties:
{
migrationId: string ,
currentStatus:
{
state: enum ,
error: string ,
currentSubStateDetails:
{
currentSubState: enum ,
dbDetails: object ,
validationDetails:
{
status: enum ,
validationStartTimeInUtc: string ,
validationEndTimeInUtc: string ,
serverLevelValidationDetails:
[
{
type: string ,
state: enum ,
messages:
[
{
state: enum ,
message: string ,
}
,
]
,
}
,
]
,
dbLevelValidationDetails:
[
{
databaseName: string ,
startedOn: string ,
endedOn: string ,
summary:
[
{
type: string ,
state: enum ,
messages:
[
{
state: enum ,
message: string ,
}
,
]
,
}
,
]
,
}
,
]
,
}
,
}
,
}
,
migrationInstanceResourceId: string ,
migrationMode: enum ,
migrationOption: enum ,
sourceType: enum ,
sslMode: enum ,
sourceDbServerMetadata:
{
location: string ,
version: string ,
storageMb: integer ,
sku:
{
name: string ,
tier: enum ,
}
,
}
,
targetDbServerMetadata:
{
location: string ,
version: string ,
storageMb: integer ,
sku:
{
name: string ,
tier: enum ,
}
,
}
,
sourceDbServerResourceId: string ,
sourceDbServerFullyQualifiedDomainName: string ,
targetDbServerResourceId: string ,
targetDbServerFullyQualifiedDomainName: string ,
secretParameters:
{
adminCredentials:
{
sourceServerPassword: string ,
targetServerPassword: string ,
}
,
sourceServerUsername: string ,
targetServerUsername: string ,
}
,
dbsToMigrate:
[
string ,
]
,
setupLogicalReplicationOnSourceDbIfNeeded: enum ,
overwriteDbsInTarget: enum ,
migrationWindowStartTimeInUtc: string ,
migrationWindowEndTimeInUtc: string ,
migrateRoles: enum ,
startDataMigration: enum ,
triggerCutover: enum ,
dbsToTriggerCutoverOn:
[
string ,
]
,
cancel: enum ,
dbsToCancelMigrationOn:
[
string ,
]
,
}
,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Migrations_Delete (new)
Description Deletes a migration.
Reference Link ¶

⚼ Request

DELETE:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{targetDbServerName}/migrations/{migrationName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
targetDbServerName: string ,
migrationName: string ,
}

⚐ Response (200)

{}

⚐ Response (204)

{}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Migrations_ListByTargetServer (new)
Description List all the migrations on a given target server.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{targetDbServerName}/migrations
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
targetDbServerName: string ,
migrationListFilter: string ,
}

⚐ Response (200)

{
value:
[
{
properties:
{
migrationId: string ,
currentStatus:
{
state: enum ,
error: string ,
currentSubStateDetails:
{
currentSubState: enum ,
dbDetails: object ,
validationDetails:
{
status: enum ,
validationStartTimeInUtc: string ,
validationEndTimeInUtc: string ,
serverLevelValidationDetails:
[
{
type: string ,
state: enum ,
messages:
[
{
state: enum ,
message: string ,
}
,
]
,
}
,
]
,
dbLevelValidationDetails:
[
{
databaseName: string ,
startedOn: string ,
endedOn: string ,
summary:
[
{
type: string ,
state: enum ,
messages:
[
{
state: enum ,
message: string ,
}
,
]
,
}
,
]
,
}
,
]
,
}
,
}
,
}
,
migrationInstanceResourceId: string ,
migrationMode: enum ,
migrationOption: enum ,
sourceType: enum ,
sslMode: enum ,
sourceDbServerMetadata:
{
location: string ,
version: string ,
storageMb: integer ,
sku:
{
name: string ,
tier: enum ,
}
,
}
,
targetDbServerMetadata:
{
location: string ,
version: string ,
storageMb: integer ,
sku:
{
name: string ,
tier: enum ,
}
,
}
,
sourceDbServerResourceId: string ,
sourceDbServerFullyQualifiedDomainName: string ,
targetDbServerResourceId: string ,
targetDbServerFullyQualifiedDomainName: string ,
secretParameters:
{
adminCredentials:
{
sourceServerPassword: string ,
targetServerPassword: string ,
}
,
sourceServerUsername: string ,
targetServerUsername: string ,
}
,
dbsToMigrate:
[
string ,
]
,
setupLogicalReplicationOnSourceDbIfNeeded: enum ,
overwriteDbsInTarget: enum ,
migrationWindowStartTimeInUtc: string ,
migrationWindowEndTimeInUtc: string ,
migrateRoles: enum ,
startDataMigration: enum ,
triggerCutover: enum ,
dbsToTriggerCutoverOn:
[
string ,
]
,
cancel: enum ,
dbsToCancelMigrationOn:
[
string ,
]
,
}
,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
CheckMigrationNameAvailability (new)
Description This method checks whether a proposed migration name is valid and available.
Reference Link ¶

⚼ Request

POST:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{targetDbServerName}/checkMigrationNameAvailability
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
targetDbServerName: string ,
parameters:
{
name: string ,
type: string ,
nameAvailable: boolean ,
reason: enum ,
message: string ,
}
,
}

⚐ Response (200)

{
name: string ,
type: string ,
nameAvailable: boolean ,
reason: enum ,
message: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Operations_List (new)
Description Lists all of the available REST API operations.
Reference Link ¶

⚼ Request

GET:  /providers/Microsoft.DBforPostgreSQL/operations
{
api-version: string ,
}

⚐ Response (200)

{
value:
[
{
name: string ,
display:
{
provider: string ,
resource: string ,
operation: string ,
description: string ,
}
,
isDataAction: boolean ,
origin: enum ,
properties: object ,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
GetPrivateDnsZoneSuffix_Execute (new)
Description Get private DNS zone suffix in the cloud
Reference Link ¶

⚼ Request

POST:  /providers/Microsoft.DBforPostgreSQL/getPrivateDnsZoneSuffix
{
api-version: string ,
}

⚐ Response (200)

{
$schema: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
PrivateEndpointConnections_Get (new)
Description Gets a private endpoint connection.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/privateEndpointConnections/{privateEndpointConnectionName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
privateEndpointConnectionName: string ,
}

⚐ Response (200)

{
properties:
{
groupIds:
[
string ,
]
,
privateEndpoint:
{
id: string ,
}
,
privateLinkServiceConnectionState:
{
status: enum ,
description: string ,
actionsRequired: string ,
}
,
provisioningState: enum ,
}
,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
PrivateEndpointConnection_Update (new)
Description Approve or reject a private endpoint connection with a given name.
Reference Link ¶

⚼ Request

PUT:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/privateEndpointConnections/{privateEndpointConnectionName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
privateEndpointConnectionName: string ,
parameters:
{
properties:
{
groupIds:
[
string ,
]
,
privateEndpoint:
{
id: string ,
}
,
privateLinkServiceConnectionState:
{
status: enum ,
description: string ,
actionsRequired: string ,
}
,
provisioningState: enum ,
}
,
}
,
}

⚐ Response (200)

{
properties:
{
groupIds:
[
string ,
]
,
privateEndpoint:
{
id: string ,
}
,
privateLinkServiceConnectionState:
{
status: enum ,
description: string ,
actionsRequired: string ,
}
,
provisioningState: enum ,
}
,
}

⚐ Response (201)

{
properties:
{
groupIds:
[
string ,
]
,
privateEndpoint:
{
id: string ,
}
,
privateLinkServiceConnectionState:
{
status: enum ,
description: string ,
actionsRequired: string ,
}
,
provisioningState: enum ,
}
,
}

⚐ Response (202)

{
location: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
PrivateEndpointConnection_Delete (new)
Description Deletes a private endpoint connection with a given name.
Reference Link ¶

⚼ Request

DELETE:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/privateEndpointConnections/{privateEndpointConnectionName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
privateEndpointConnectionName: string ,
}

⚐ Response (202)

{
location: string ,
}

⚐ Response (204)

{}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
PrivateEndpointConnections_ListByServer (new)
Description Gets all private endpoint connections on a server.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/privateEndpointConnections
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
}

⚐ Response (200)

{
value:
[
{
properties:
{
groupIds:
[
string ,
]
,
privateEndpoint:
{
id: string ,
}
,
privateLinkServiceConnectionState:
{
status: enum ,
description: string ,
actionsRequired: string ,
}
,
provisioningState: enum ,
}
,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
PrivateLinkResources_ListByServer (new)
Description Gets the private link resources for PostgreSQL server.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/privateLinkResources
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
}

⚐ Response (200)

{
value:
[
{
properties:
{
groupId: string ,
requiredMembers:
[
string ,
]
,
requiredZoneNames:
[
string ,
]
,
}
,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
PrivateLinkResources_Get (new)
Description Gets a private link resource for PostgreSQL server.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/privateLinkResources/{groupName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
groupName: string ,
}

⚐ Response (200)

{
properties:
{
groupId: string ,
requiredMembers:
[
string ,
]
,
requiredZoneNames:
[
string ,
]
,
}
,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
QuotaUsages_List (new)
Description Get quota usages at specified location in a given subscription.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/providers/Microsoft.DBforPostgreSQL/locations/{locationName}/resourceType/flexibleServers/usages
{
api-version: string ,
subscriptionId: string ,
locationName: string ,
}

⚐ Response (200)

{
value:
[
{
name:
{
value: string ,
localizedValue: string ,
}
,
limit: integer ,
unit: string ,
currentValue: integer ,
id: string ,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Replicas_ListByServer (new)
Description List all the replicas for a given server.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/replicas
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
}

⚐ Response (200)

{
value:
[
{
sku:
{
name: string ,
tier: enum ,
}
,
identity:
{
userAssignedIdentities: object ,
principalId: string ,
type: enum ,
tenantId: string ,
}
,
properties:
{
administratorLogin: string ,
administratorLoginPassword: string ,
version: enum ,
minorVersion: string ,
state: enum ,
fullyQualifiedDomainName: string ,
storage:
{
storageSizeGB: integer ,
autoGrow: enum ,
tier: enum ,
iops: integer ,
throughput: integer ,
type: enum ,
}
,
authConfig:
{
activeDirectoryAuth: enum ,
passwordAuth: enum ,
tenantId: string ,
}
,
dataEncryption:
{
primaryKeyURI: string ,
primaryUserAssignedIdentityId: string ,
geoBackupKeyURI: string ,
geoBackupUserAssignedIdentityId: string ,
type: enum ,
primaryEncryptionKeyStatus: enum ,
geoBackupEncryptionKeyStatus: enum ,
}
,
backup:
{
backupRetentionDays: integer ,
geoRedundantBackup: enum ,
earliestRestoreDate: string ,
}
,
network:
{
publicNetworkAccess: enum ,
delegatedSubnetResourceId: string ,
privateDnsZoneArmResourceId: string ,
}
,
highAvailability:
{
mode: enum ,
state: enum ,
standbyAvailabilityZone: string ,
}
,
maintenanceWindow:
{
customWindow: string ,
startHour: integer ,
startMinute: integer ,
dayOfWeek: integer ,
}
,
sourceServerResourceId: string ,
pointInTimeUTC: string ,
availabilityZone: string ,
replicationRole: enum ,
replicaCapacity: integer ,
replica:
{
role: enum ,
capacity: integer ,
replicationState: enum ,
promoteMode: enum ,
promoteOption: enum ,
}
,
createMode: enum ,
privateEndpointConnections:
[
{
properties:
{
groupIds:
[
string ,
]
,
privateEndpoint:
{
id: string ,
}
,
privateLinkServiceConnectionState:
{
status: enum ,
description: string ,
actionsRequired: string ,
}
,
provisioningState: enum ,
}
,
}
,
]
,
cluster:
{
clusterSize: integer ,
}
,
}
,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
LogFiles_ListByServer (new)
Description List all the server log files in a given server.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/logFiles
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
}

⚐ Response (200)

{
value:
[
{
properties:
{
createdTime: string ,
lastModifiedTime: string ,
sizeInKb: integer ,
type: string ,
url: string ,
}
,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Servers_Restart (new)
Description Restarts a server.
Reference Link ¶

⚼ Request

POST:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/restart
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
parameters:
{
restartWithFailover: boolean ,
failoverMode: enum ,
}
,
}

⚐ Response (200)

{}

⚐ Response (202)

{
location: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Servers_Start (new)
Description Starts a server.
Reference Link ¶

⚼ Request

POST:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/start
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
}

⚐ Response (200)

{}

⚐ Response (202)

{
location: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
Servers_Stop (new)
Description Stops a server.
Reference Link ¶

⚼ Request

POST:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/stop
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
}

⚐ Response (200)

{}

⚐ Response (202)

{
location: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
ServerThreatProtectionSettings_ListByServer (new)
Description Get a list of server's Threat Protection state.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/advancedThreatProtectionSettings
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
}

⚐ Response (200)

{
value:
[
{
properties:
{
state: enum ,
creationTime: string ,
}
,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
ServerThreatProtectionSettings_Get (new)
Description Get a server's Advanced Threat Protection settings.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/advancedThreatProtectionSettings/{threatProtectionName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
threatProtectionName: string ,
}

⚐ Response (200)

{
properties:
{
state: enum ,
creationTime: string ,
}
,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
ServerThreatProtectionSettings_CreateOrUpdate (new)
Description Creates or updates a server's Advanced Threat Protection settings.
Reference Link ¶

⚼ Request

PUT:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/advancedThreatProtectionSettings/{threatProtectionName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
threatProtectionName: string ,
parameters:
{
properties:
{
state: enum ,
creationTime: string ,
}
,
}
,
}

⚐ Response (200)

{
properties:
{
state: enum ,
creationTime: string ,
}
,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}

⚐ Response (201)

{
properties:
{
state: enum ,
creationTime: string ,
}
,
}

⚐ Response (202)

{
location: string ,
}
TuningOptions_Get (new)
Description Retrieve the tuning option on a server.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/tuningOptions/{tuningOption}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
tuningOption: string ,
}

⚐ Response (200)

{
$schema: object ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
TuningIndex_ListRecommendations (new)
Description Retrieve the list of available tuning index recommendations.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/tuningOptions/{tuningOption}/recommendations
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
tuningOption: string ,
recommendationType: string ,
}

⚐ Response (200)

{
value:
[
{
properties:
{
initialRecommendedTime: string ,
lastRecommendedTime: string ,
timesRecommended: integer ,
improvedQueryIds:
[
integer ,
]
,
recommendationReason: string ,
recommendationType: enum ,
implementationDetails:
{
method: string ,
script: string ,
}
,
analyzedWorkload:
{
startTime: string ,
endTime: string ,
queryCount: integer ,
}
,
estimatedImpact:
[
{
dimensionName: string ,
unit: string ,
queryId: integer ,
absoluteValue: number ,
}
,
]
,
details:
{
databaseName: string ,
schema: string ,
table: string ,
indexType: string ,
indexName: string ,
indexColumns:
[
string ,
]
,
includedColumns:
[
string ,
]
,
}
,
}
,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
TuningConfiguration_Enable (new)
Description Enables the config tuning.
Reference Link ¶

⚼ Request

POST:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/tuningOptions/{tuningOption}/enable
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
tuningOption: string ,
}

⚐ Response (202)

{
location: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
TuningConfiguration_Disable (new)
Description Disables the config tuning.
Reference Link ¶

⚼ Request

POST:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/tuningOptions/{tuningOption}/disable
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
tuningOption: string ,
}

⚐ Response (202)

{
location: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
TuningConfiguration_StartSession (new)
Description Starts up the config tuning session.
Reference Link ¶

⚼ Request

POST:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/tuningOptions/{tuningOption}/startSession
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
tuningOption: string ,
configTuningRequest:
{
serverName: string ,
allowServerRestarts: boolean ,
targetImprovementMetric: string ,
configTuningUsageMode: boolean ,
}
,
}

⚐ Response (202)

{
location: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
TuningConfiguration_StopSession (new)
Description Stops the config tuning session.
Reference Link ¶

⚼ Request

POST:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/tuningOptions/{tuningOption}/stopSession
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
tuningOption: string ,
}

⚐ Response (202)

{
location: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
TuningConfiguration_ListSessions (new)
Description Gets up the config tuning session status.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/tuningOptions/{tuningOption}/sessions
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
tuningOption: string ,
}

⚐ Response (200)

{
value:
[
{
sessionStartTime: string ,
sessionId: string ,
status: string ,
preTuningAqr: string ,
postTuningAqr: string ,
preTuningTps: string ,
postTuningTps: string ,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
TuningConfiguration_ListSessionDetails (new)
Description Gets the session details of a config tuning session.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/tuningOptions/{tuningOption}/sessionDetails
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
tuningOption: string ,
sessionId: string ,
}

⚐ Response (200)

{
value:
[
{
iterationId: string ,
sessionId: string ,
appliedConfiguration: string ,
iterationStartTime: string ,
averageQueryRuntimeMs: string ,
transactionsPerSecond: string ,
}
,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
TuningOptions_ListByServer (new)
Description Retrieve the list of available tuning options.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/tuningOptions
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
}

⚐ Response (200)

{
value:
[
object ,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
VirtualEndpoints_Create (new)
Description Creates a new virtual endpoint for PostgreSQL flexible server.
Reference Link ¶

⚼ Request

PUT:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/virtualendpoints/{virtualEndpointName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
virtualEndpointName: string ,
parameters: object ,
}

⚐ Response (200)

{
$schema: object ,
}

⚐ Response (201)

{
$schema: object ,
}

⚐ Response (202)

{
location: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
VirtualEndpoints_Update (new)
Description Updates an existing virtual endpoint. The request body can contain one to many of the properties present in the normal virtual endpoint definition.
Reference Link ¶

⚼ Request

PATCH:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/virtualendpoints/{virtualEndpointName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
virtualEndpointName: string ,
parameters:
{
properties:
{
endpointType: enum ,
members:
[
string ,
]
,
virtualEndpoints:
[
string ,
]
,
}
,
}
,
}

⚐ Response (200)

{
$schema: object ,
}

⚐ Response (202)

{
location: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
VirtualEndpoints_Delete (new)
Description Deletes a virtual endpoint.
Reference Link ¶

⚼ Request

DELETE:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/virtualendpoints/{virtualEndpointName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
virtualEndpointName: string ,
}

⚐ Response (202)

{
location: string ,
}

⚐ Response (204)

{}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
VirtualEndpoints_Get (new)
Description Gets information about a virtual endpoint.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/virtualendpoints/{virtualEndpointName}
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
virtualEndpointName: string ,
}

⚐ Response (200)

{
$schema: object ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
VirtualEndpoints_ListByServer (new)
Description List all the servers in a given resource group.
Reference Link ¶

⚼ Request

GET:  /subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.DBforPostgreSQL/flexibleServers/{serverName}/virtualendpoints
{
api-version: string ,
subscriptionId: string ,
resourceGroupName: string ,
serverName: string ,
}

⚐ Response (200)

{
value:
[
object ,
]
,
nextLink: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}
VirtualNetworkSubnetUsage_Execute (new)
Description Get virtual network subnet usage for a given vNet resource id.
Reference Link ¶

⚼ Request

POST:  /subscriptions/{subscriptionId}/providers/Microsoft.DBforPostgreSQL/locations/{locationName}/checkVirtualNetworkSubnetUsage
{
api-version: string ,
subscriptionId: string ,
locationName: string ,
parameters:
{
virtualNetworkArmResourceId: string ,
}
,
}

⚐ Response (200)

{
delegatedSubnetsUsage:
[
{
subnetName: string ,
usage: integer ,
}
,
]
,
location: string ,
subscriptionId: string ,
}

⚐ Response (default)

{
error:
{
code: string ,
message: string ,
target: string ,
details:
[
string ,
]
,
additionalInfo:
[
{
type: string ,
info: object ,
}
,
]
,
}
,
}