Microsoft.DBforPostgreSQL serverGroupsv2

Article
10/25/2024

Bicep resource definition

The serverGroupsv2 resource type can be deployed with operations that target:

Resource groups - See resource group deployment commands

For a list of changed properties in each API version, see change log.

Resource format

To create a Microsoft.DBforPostgreSQL/serverGroupsv2 resource, add the following Bicep to your template.

resource symbolicname 'Microsoft.DBforPostgreSQL/serverGroupsv2@2023-03-02-preview' = {
  identity: {
    type: 'string'
    userAssignedIdentities: {
      {customized property}: {}
    }
  }
  location: 'string'
  name: 'string'
  properties: {
    administratorLoginPassword: 'string'
    authConfig: {
      activeDirectoryAuth: 'string'
      passwordAuth: 'string'
    }
    citusVersion: 'string'
    coordinatorEnablePublicIpAccess: bool
    coordinatorServerEdition: 'string'
    coordinatorStorageQuotaInMb: int
    coordinatorVCores: int
    databaseName: 'string'
    dataEncryption: {
      primaryKeyUri: 'string'
      primaryUserAssignedIdentityId: 'string'
      type: 'string'
    }
    enableGeoBackup: bool
    enableHa: bool
    enableShardsOnCoordinator: bool
    maintenanceWindow: {
      customWindow: 'string'
      dayOfWeek: int
      startHour: int
      startMinute: int
    }
    nodeCount: int
    nodeEnablePublicIpAccess: bool
    nodeServerEdition: 'string'
    nodeStorageQuotaInMb: int
    nodeVCores: int
    pointInTimeUTC: 'string'
    postgresqlVersion: 'string'
    preferredPrimaryZone: 'string'
    sourceLocation: 'string'
    sourceResourceId: 'string'
  }
  tags: {
    {customized property}: 'string'
  }
}

Property values

AuthConfig

Name	Description	Value
activeDirectoryAuth		'disabled' 'enabled'
passwordAuth		'disabled' 'enabled'

ClusterProperties

Name	Description	Value
administratorLoginPassword	The password of the administrator login. Required for creation.	string Constraints: Sensitive value. Pass in as a secure parameter.
authConfig	Authentication configuration of a cluster.	AuthConfig
citusVersion	The Citus extension version on all cluster servers.	string
coordinatorEnablePublicIpAccess	If public access is enabled on coordinator.	bool
coordinatorServerEdition	The edition of a coordinator server (default: GeneralPurpose). Required for creation.	string
coordinatorStorageQuotaInMb	The storage of a server in MB. Required for creation. See /azure/cosmos-db/postgresql/resources-compute for more information.	int
coordinatorVCores	The vCores count of a server (max: 96). Required for creation. See /azure/cosmos-db/postgresql/resources-compute for more information.	int
databaseName	The database name of the cluster. Only one database per cluster is supported.	string
dataEncryption	The data encryption properties of a cluster.	DataEncryption
enableGeoBackup	If cluster backup is stored in another Azure region in addition to the copy of the backup stored in the cluster's region. Enabled only at the time of cluster creation.	bool
enableHa	If high availability (HA) is enabled or not for the cluster.	bool
enableShardsOnCoordinator	If distributed tables are placed on coordinator or not. Should be set to 'true' on single node clusters. Requires shard rebalancing after value is changed.	bool
maintenanceWindow	Maintenance window of a cluster.	MaintenanceWindow
nodeCount	Worker node count of the cluster. When node count is 0, it represents a single node configuration with the ability to create distributed tables on that node. 2 or more worker nodes represent multi-node configuration. Node count value cannot be 1. Required for creation.	int
nodeEnablePublicIpAccess	If public access is enabled on worker nodes.	bool
nodeServerEdition	The edition of a node server (default: MemoryOptimized).	string
nodeStorageQuotaInMb	The storage in MB on each worker node. See /azure/cosmos-db/postgresql/resources-compute for more information.	int
nodeVCores	The compute in vCores on each worker node (max: 104). See /azure/cosmos-db/postgresql/resources-compute for more information.	int
pointInTimeUTC	Date and time in UTC (ISO8601 format) for cluster restore.	string
postgresqlVersion	The major PostgreSQL version on all cluster servers.	string
preferredPrimaryZone	Preferred primary availability zone (AZ) for all cluster servers.	string
sourceLocation	The Azure region of source cluster for read replica clusters.	string
sourceResourceId	The resource id of source cluster for read replica clusters.	string

DataEncryption

Name	Description	Value
primaryKeyUri	URI for the key in keyvault for data encryption of the primary server.	string
primaryUserAssignedIdentityId	Resource Id for the User assigned identity to be used for data encryption of the primary server.	string
type		'AzureKeyVault' 'SystemAssigned'

IdentityProperties

Name	Description	Value
type		'SystemAssigned' 'UserAssigned'
userAssignedIdentities	The set of user assigned identities associated with the resource. The userAssignedIdentities dictionary keys will be ARM resource ids in the form: '/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.ManagedIdentity/userAssignedIdentities/{identityName}. The dictionary values can be empty objects ({}) in requests.	UserAssignedIdentities

MaintenanceWindow

Name	Description	Value
customWindow	Indicates whether custom maintenance window is enabled or not.	string
dayOfWeek	Preferred day of the week for maintenance window.	int
startHour	Start hour within preferred day of the week for maintenance window.	int
startMinute	Start minute within the start hour for maintenance window.	int

Microsoft.DBforPostgreSQL/serverGroupsv2

Name	Description	Value
identity	Describes the identity of the cluster.	IdentityProperties
location	The geo-location where the resource lives	string (required)
name	The resource name	string Constraints: Min length = 3 Max length = 3 Pattern = `^(?![0-9]+$)(?!-)[a-z0-9-]{3,40}(?<!-)$` (required)
properties	Properties of the cluster.	ClusterProperties
tags	Resource tags	Dictionary of tag names and values. See Tags in templates

TrackedResourceTags

Name	Description	Value

UserAssignedIdentities

Name	Description	Value

UserAssignedIdentity

Name	Description	Value

ARM template resource definition

The serverGroupsv2 resource type can be deployed with operations that target:

Resource groups - See resource group deployment commands

For a list of changed properties in each API version, see change log.

Resource format

To create a Microsoft.DBforPostgreSQL/serverGroupsv2 resource, add the following JSON to your template.

{
  "type": "Microsoft.DBforPostgreSQL/serverGroupsv2",
  "apiVersion": "2023-03-02-preview",
  "name": "string",
  "identity": {
    "type": "string",
    "userAssignedIdentities": {
      "{customized property}": {
      }
    }
  },
  "location": "string",
  "properties": {
    "administratorLoginPassword": "string",
    "authConfig": {
      "activeDirectoryAuth": "string",
      "passwordAuth": "string"
    },
    "citusVersion": "string",
    "coordinatorEnablePublicIpAccess": "bool",
    "coordinatorServerEdition": "string",
    "coordinatorStorageQuotaInMb": "int",
    "coordinatorVCores": "int",
    "databaseName": "string",
    "dataEncryption": {
      "primaryKeyUri": "string",
      "primaryUserAssignedIdentityId": "string",
      "type": "string"
    },
    "enableGeoBackup": "bool",
    "enableHa": "bool",
    "enableShardsOnCoordinator": "bool",
    "maintenanceWindow": {
      "customWindow": "string",
      "dayOfWeek": "int",
      "startHour": "int",
      "startMinute": "int"
    },
    "nodeCount": "int",
    "nodeEnablePublicIpAccess": "bool",
    "nodeServerEdition": "string",
    "nodeStorageQuotaInMb": "int",
    "nodeVCores": "int",
    "pointInTimeUTC": "string",
    "postgresqlVersion": "string",
    "preferredPrimaryZone": "string",
    "sourceLocation": "string",
    "sourceResourceId": "string"
  },
  "tags": {
    "{customized property}": "string"
  }
}

Property values

AuthConfig

Name	Description	Value
activeDirectoryAuth		'disabled' 'enabled'
passwordAuth		'disabled' 'enabled'

ClusterProperties

Name	Description	Value
administratorLoginPassword	The password of the administrator login. Required for creation.	string Constraints: Sensitive value. Pass in as a secure parameter.
authConfig	Authentication configuration of a cluster.	AuthConfig
citusVersion	The Citus extension version on all cluster servers.	string
coordinatorEnablePublicIpAccess	If public access is enabled on coordinator.	bool
coordinatorServerEdition	The edition of a coordinator server (default: GeneralPurpose). Required for creation.	string
coordinatorStorageQuotaInMb	The storage of a server in MB. Required for creation. See /azure/cosmos-db/postgresql/resources-compute for more information.	int
coordinatorVCores	The vCores count of a server (max: 96). Required for creation. See /azure/cosmos-db/postgresql/resources-compute for more information.	int
databaseName	The database name of the cluster. Only one database per cluster is supported.	string
dataEncryption	The data encryption properties of a cluster.	DataEncryption
enableGeoBackup	If cluster backup is stored in another Azure region in addition to the copy of the backup stored in the cluster's region. Enabled only at the time of cluster creation.	bool
enableHa	If high availability (HA) is enabled or not for the cluster.	bool
enableShardsOnCoordinator	If distributed tables are placed on coordinator or not. Should be set to 'true' on single node clusters. Requires shard rebalancing after value is changed.	bool
maintenanceWindow	Maintenance window of a cluster.	MaintenanceWindow
nodeCount	Worker node count of the cluster. When node count is 0, it represents a single node configuration with the ability to create distributed tables on that node. 2 or more worker nodes represent multi-node configuration. Node count value cannot be 1. Required for creation.	int
nodeEnablePublicIpAccess	If public access is enabled on worker nodes.	bool
nodeServerEdition	The edition of a node server (default: MemoryOptimized).	string
nodeStorageQuotaInMb	The storage in MB on each worker node. See /azure/cosmos-db/postgresql/resources-compute for more information.	int
nodeVCores	The compute in vCores on each worker node (max: 104). See /azure/cosmos-db/postgresql/resources-compute for more information.	int
pointInTimeUTC	Date and time in UTC (ISO8601 format) for cluster restore.	string
postgresqlVersion	The major PostgreSQL version on all cluster servers.	string
preferredPrimaryZone	Preferred primary availability zone (AZ) for all cluster servers.	string
sourceLocation	The Azure region of source cluster for read replica clusters.	string
sourceResourceId	The resource id of source cluster for read replica clusters.	string

DataEncryption

Name	Description	Value
primaryKeyUri	URI for the key in keyvault for data encryption of the primary server.	string
primaryUserAssignedIdentityId	Resource Id for the User assigned identity to be used for data encryption of the primary server.	string
type		'AzureKeyVault' 'SystemAssigned'

IdentityProperties

Name	Description	Value
type		'SystemAssigned' 'UserAssigned'
userAssignedIdentities	The set of user assigned identities associated with the resource. The userAssignedIdentities dictionary keys will be ARM resource ids in the form: '/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.ManagedIdentity/userAssignedIdentities/{identityName}. The dictionary values can be empty objects ({}) in requests.	UserAssignedIdentities

MaintenanceWindow

Name	Description	Value
customWindow	Indicates whether custom maintenance window is enabled or not.	string
dayOfWeek	Preferred day of the week for maintenance window.	int
startHour	Start hour within preferred day of the week for maintenance window.	int
startMinute	Start minute within the start hour for maintenance window.	int

Microsoft.DBforPostgreSQL/serverGroupsv2

Name	Description	Value
apiVersion	The api version	'2023-03-02-preview'
identity	Describes the identity of the cluster.	IdentityProperties
location	The geo-location where the resource lives	string (required)
name	The resource name	string Constraints: Min length = 3 Max length = 3 Pattern = `^(?![0-9]+$)(?!-)[a-z0-9-]{3,40}(?<!-)$` (required)
properties	Properties of the cluster.	ClusterProperties
tags	Resource tags	Dictionary of tag names and values. See Tags in templates
type	The resource type	'Microsoft.DBforPostgreSQL/serverGroupsv2'

TrackedResourceTags

Name	Description	Value

UserAssignedIdentities

Name	Description	Value

UserAssignedIdentity

Name	Description	Value

Terraform (AzAPI provider) resource definition

The serverGroupsv2 resource type can be deployed with operations that target:

Resource groups

For a list of changed properties in each API version, see change log.

Resource format

To create a Microsoft.DBforPostgreSQL/serverGroupsv2 resource, add the following Terraform to your template.

resource "azapi_resource" "symbolicname" {
  type = "Microsoft.DBforPostgreSQL/serverGroupsv2@2023-03-02-preview"
  name = "string"
  identity = {
    type = "string"
    userAssignedIdentities = {
      {customized property} = {
      }
    }
  }
  location = "string"
  body = jsonencode({
    properties = {
      administratorLoginPassword = "string"
      authConfig = {
        activeDirectoryAuth = "string"
        passwordAuth = "string"
      }
      citusVersion = "string"
      coordinatorEnablePublicIpAccess = bool
      coordinatorServerEdition = "string"
      coordinatorStorageQuotaInMb = int
      coordinatorVCores = int
      databaseName = "string"
      dataEncryption = {
        primaryKeyUri = "string"
        primaryUserAssignedIdentityId = "string"
        type = "string"
      }
      enableGeoBackup = bool
      enableHa = bool
      enableShardsOnCoordinator = bool
      maintenanceWindow = {
        customWindow = "string"
        dayOfWeek = int
        startHour = int
        startMinute = int
      }
      nodeCount = int
      nodeEnablePublicIpAccess = bool
      nodeServerEdition = "string"
      nodeStorageQuotaInMb = int
      nodeVCores = int
      pointInTimeUTC = "string"
      postgresqlVersion = "string"
      preferredPrimaryZone = "string"
      sourceLocation = "string"
      sourceResourceId = "string"
    }
  })
  tags = {
    {customized property} = "string"
  }
}

Property values

AuthConfig

Name	Description	Value
activeDirectoryAuth		'disabled' 'enabled'
passwordAuth		'disabled' 'enabled'

ClusterProperties

Name	Description	Value
administratorLoginPassword	The password of the administrator login. Required for creation.	string Constraints: Sensitive value. Pass in as a secure parameter.
authConfig	Authentication configuration of a cluster.	AuthConfig
citusVersion	The Citus extension version on all cluster servers.	string
coordinatorEnablePublicIpAccess	If public access is enabled on coordinator.	bool
coordinatorServerEdition	The edition of a coordinator server (default: GeneralPurpose). Required for creation.	string
coordinatorStorageQuotaInMb	The storage of a server in MB. Required for creation. See /azure/cosmos-db/postgresql/resources-compute for more information.	int
coordinatorVCores	The vCores count of a server (max: 96). Required for creation. See /azure/cosmos-db/postgresql/resources-compute for more information.	int
databaseName	The database name of the cluster. Only one database per cluster is supported.	string
dataEncryption	The data encryption properties of a cluster.	DataEncryption
enableGeoBackup	If cluster backup is stored in another Azure region in addition to the copy of the backup stored in the cluster's region. Enabled only at the time of cluster creation.	bool
enableHa	If high availability (HA) is enabled or not for the cluster.	bool
enableShardsOnCoordinator	If distributed tables are placed on coordinator or not. Should be set to 'true' on single node clusters. Requires shard rebalancing after value is changed.	bool
maintenanceWindow	Maintenance window of a cluster.	MaintenanceWindow
nodeCount	Worker node count of the cluster. When node count is 0, it represents a single node configuration with the ability to create distributed tables on that node. 2 or more worker nodes represent multi-node configuration. Node count value cannot be 1. Required for creation.	int
nodeEnablePublicIpAccess	If public access is enabled on worker nodes.	bool
nodeServerEdition	The edition of a node server (default: MemoryOptimized).	string
nodeStorageQuotaInMb	The storage in MB on each worker node. See /azure/cosmos-db/postgresql/resources-compute for more information.	int
nodeVCores	The compute in vCores on each worker node (max: 104). See /azure/cosmos-db/postgresql/resources-compute for more information.	int
pointInTimeUTC	Date and time in UTC (ISO8601 format) for cluster restore.	string
postgresqlVersion	The major PostgreSQL version on all cluster servers.	string
preferredPrimaryZone	Preferred primary availability zone (AZ) for all cluster servers.	string
sourceLocation	The Azure region of source cluster for read replica clusters.	string
sourceResourceId	The resource id of source cluster for read replica clusters.	string

DataEncryption

Name	Description	Value
primaryKeyUri	URI for the key in keyvault for data encryption of the primary server.	string
primaryUserAssignedIdentityId	Resource Id for the User assigned identity to be used for data encryption of the primary server.	string
type		'AzureKeyVault' 'SystemAssigned'

IdentityProperties

Name	Description	Value
type		'SystemAssigned' 'UserAssigned'
userAssignedIdentities	The set of user assigned identities associated with the resource. The userAssignedIdentities dictionary keys will be ARM resource ids in the form: '/subscriptions/{subscriptionId}/resourceGroups/{resourceGroupName}/providers/Microsoft.ManagedIdentity/userAssignedIdentities/{identityName}. The dictionary values can be empty objects ({}) in requests.	UserAssignedIdentities

MaintenanceWindow

Name	Description	Value
customWindow	Indicates whether custom maintenance window is enabled or not.	string
dayOfWeek	Preferred day of the week for maintenance window.	int
startHour	Start hour within preferred day of the week for maintenance window.	int
startMinute	Start minute within the start hour for maintenance window.	int

Microsoft.DBforPostgreSQL/serverGroupsv2

Name	Description	Value
identity	Describes the identity of the cluster.	IdentityProperties
location	The geo-location where the resource lives	string (required)
name	The resource name	string Constraints: Min length = 3 Max length = 3 Pattern = `^(?![0-9]+$)(?!-)[a-z0-9-]{3,40}(?<!-)$` (required)
properties	Properties of the cluster.	ClusterProperties
tags	Resource tags	Dictionary of tag names and values.
type	The resource type	"Microsoft.DBforPostgreSQL/serverGroupsv2@2023-03-02-preview"

TrackedResourceTags

Name	Description	Value

UserAssignedIdentities

Name	Description	Value

UserAssignedIdentity

Name	Description	Value

Share via

Microsoft.DBforPostgreSQL serverGroupsv2

Bicep resource definition

Resource format

Property values

AuthConfig

ClusterProperties

DataEncryption

IdentityProperties

MaintenanceWindow

Microsoft.DBforPostgreSQL/serverGroupsv2

TrackedResourceTags

UserAssignedIdentities

UserAssignedIdentity

ARM template resource definition

Resource format

Property values

AuthConfig

ClusterProperties

DataEncryption

IdentityProperties

MaintenanceWindow

Microsoft.DBforPostgreSQL/serverGroupsv2

TrackedResourceTags

UserAssignedIdentities

UserAssignedIdentity

Terraform (AzAPI provider) resource definition

Resource format

Property values

AuthConfig

ClusterProperties

DataEncryption

IdentityProperties

MaintenanceWindow

Microsoft.DBforPostgreSQL/serverGroupsv2

TrackedResourceTags

UserAssignedIdentities

UserAssignedIdentity

Feedback

Additional resources