capabilities_by_location

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

Overview

Name	capabilities_by_location
Type	Resource
Id	azure.postgresql_flexible_servers.capabilities_by_location

Fields

The following fields are returned by SELECT queries:

list

Name	Datatype	Description
name	string	Name of flexible servers capabilities.
fastProvisioningSupported	string	Indicates if fast provisioning is supported. 'Enabled' means fast provisioning is supported. 'Disabled' stands for fast provisioning is not supported. Will be deprecated in the future. Look to Supported Features for 'FastProvisioning'. Known values are: "Enabled" and "Disabled". (Enabled, Disabled)
geoBackupSupported	string	Indicates if geographically redundant backups are supported in this location. 'Enabled' means geographically redundant backups are supported. 'Disabled' stands for geographically redundant backup is not supported. Will be deprecated in the future. Look to Supported Features for 'GeoBackup'. Known values are: "Enabled" and "Disabled". (Enabled, Disabled)
onlineResizeSupported	string	Indicates if resizing the storage, without interrupting the operation of the database engine, is supported in this location for the given subscription. 'Enabled' means resizing the storage without interrupting the operation of the database engine is supported. 'Disabled' means resizing the storage without interrupting the operation of the database engine is not supported. Will be deprecated in the future. Look to Supported Features for 'OnlineResize'. Known values are: "Enabled" and "Disabled". (Enabled, Disabled)
reason	string	Reason for the capability not being available.
restricted	string	Indicates if this location is restricted. 'Enabled' means location is restricted. 'Disabled' stands for location is not restricted. Will be deprecated in the future. Look to Supported Features for 'Restricted'. Known values are: "Enabled" and "Disabled". (Enabled, Disabled)
status	string	Status of the capability. Known values are: "Visible", "Available", "Default", and "Disabled". (Visible, Available, Default, Disabled)
storageAutoGrowthSupported	string	Indicates if storage autogrow is supported in this location. 'Enabled' means storage autogrow is supported. 'Disabled' stands for storage autogrow is not supported. Will be deprecated in the future. Look to Supported Features for 'StorageAutoGrowth'. Known values are: "Enabled" and "Disabled". (Enabled, Disabled)
supportedFastProvisioningEditions	array	List of compute tiers supporting fast provisioning.
supportedFeatures	array	Features supported.
supportedServerEditions	array	List of supported compute tiers.
supportedServerVersions	array	List of supported major versions of PostgreSQL database engine.
zoneRedundantHaAndGeoBackupSupported	string	Indicates if high availability with zone redundancy is supported in conjunction with geographically redundant backups in this location. 'Enabled' means high availability with zone redundancy is supported in conjunction with geographically redundant backups is supported. 'Disabled' stands for high availability with zone redundancy is supported in conjunction with geographically redundant backups is not supported. Will be deprecated in the future. Look to Supported Features for 'ZoneRedundantHaAndGeoBackup'. Known values are: "Enabled" and "Disabled". (Enabled, Disabled)
zoneRedundantHaSupported	string	Indicates if high availability with zone redundancy is supported in this location. 'Enabled' means high availability with zone redundancy is supported. 'Disabled' stands for high availability with zone redundancy is not supported. Will be deprecated in the future. Look to Supported Features for 'ZoneRedundantHa'. Known values are: "Enabled" and "Disabled". (Enabled, Disabled)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	location_name, subscription_id		Lists the capabilities available in a given location for a specific subscription.

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
location_name	string	The name of the location. Required.
subscription_id	string

SELECT examples

list

Lists the capabilities available in a given location for a specific subscription.

SELECT
name,
fastProvisioningSupported,
geoBackupSupported,
onlineResizeSupported,
reason,
restricted,
status,
storageAutoGrowthSupported,
supportedFastProvisioningEditions,
supportedFeatures,
supportedServerEditions,
supportedServerVersions,
zoneRedundantHaAndGeoBackupSupported,
zoneRedundantHaSupported
FROM azure.postgresql_flexible_servers.capabilities_by_location
WHERE location_name = '{{ location_name }}' -- required
AND subscription_id = '{{ subscription_id }}' -- required
;