capabilities_by_server

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

Overview

Name	capabilities_by_server
Type	Resource
Id	azure.postgresql_flexible_servers.capabilities_by_server

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	resource_group_name, server_name, subscription_id		Lists the capabilities available for a given 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
resource_group_name	string	The name of the resource group. The name is case insensitive. Required.
server_name	string	The name of the server. Required.
subscription_id	string

SELECT examples

list

Lists the capabilities available for a given server.

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