server_capabilities

Creates, updates, deletes, gets or lists a server_capabilities resource.

Overview

Name	server_capabilities
Type	Resource
Id	azure.postgresql.server_capabilities

Fields

The following fields are returned by SELECT queries:

list

Name	Datatype	Description
name	string	Name of flexible servers capability
fastProvisioningSupported	string	Gets a value indicating whether fast provisioning is supported. "Enabled" means fast provisioning is supported. "Disabled" stands for fast provisioning is not supported.
geoBackupSupported	string	Determines if geo-backup is supported in this region. "Enabled" means geo-backup is supported. "Disabled" stands for geo-back is not supported.
onlineResizeSupported	string	A value indicating whether online resize is supported in this region for the given subscription. "Enabled" means storage online resize is supported. "Disabled" means storage online resize is not supported.
reason	string	The reason for the capability not being available.
restricted	string	A value indicating whether this region is restricted. "Enabled" means region is restricted. "Disabled" stands for region is not restricted.
status	string	The status of the capability.
storageAutoGrowthSupported	string	A value indicating whether storage auto-grow is supported in this region. "Enabled" means storage auto-grow is supported. "Disabled" stands for storage auto-grow is not supported.
supportedFastProvisioningEditions	array	List of supported server editions for fast provisioning
supportedServerEditions	array	List of supported flexible server editions
supportedServerVersions	array	The list of server versions supported for this capability.
zoneRedundantHaAndGeoBackupSupported	string	A value indicating whether Zone Redundant HA and Geo-backup is supported in this region. "Enabled" means zone redundant HA and geo-backup is supported. "Disabled" stands for zone redundant HA and geo-backup is not supported.
zoneRedundantHaSupported	string	A value indicating whether Zone Redundant HA is supported in this region. "Enabled" means zone redundant HA is supported. "Disabled" stands for zone redundant HA is not supported.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	subscriptionId, resourceGroupName, serverName		Get capabilities for a flexible server.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
resourceGroupName	string	The name of the resource group. The name is case insensitive.
serverName	string	The name of the server.
subscriptionId	string (uuid)	The ID of the target subscription. The value must be an UUID.

SELECT examples

list

Get capabilities for a flexible server.

SELECT
name,
fastProvisioningSupported,
geoBackupSupported,
onlineResizeSupported,
reason,
restricted,
status,
storageAutoGrowthSupported,
supportedFastProvisioningEditions,
supportedServerEditions,
supportedServerVersions,
zoneRedundantHaAndGeoBackupSupported,
zoneRedundantHaSupported
FROM azure.postgresql.server_capabilities
WHERE subscriptionId = '{{ subscriptionId }}' -- required
AND resourceGroupName = '{{ resourceGroupName }}' -- required
AND serverName = '{{ serverName }}' -- required
;