Microsoft.DBforPostgreSQL servers/databases

• Latest
• 2017-12-01
• 2017-12-01-preview

Bicep resource definition

The servers/databases 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/servers/databases resource, add the following Bicep to your template.

resource symbolicname 'Microsoft.DBforPostgreSQL/servers/databases@2017-12-01' = {
  name: 'string'
  parent: resourceSymbolicName
  properties: {
    charset: 'string'
    collation: 'string'
  }
}

Property values

servers/databases

Name	Description	Value
name	The resource name See how to set names and types for child resources in Bicep.	string (required) Character limit: 1-63 Valid characters: Alphanumerics and hyphens.
parent	In Bicep, you can specify the parent resource for a child resource. You only need to add this property when the child resource is declared outside of the parent resource. For more information, see Child resource outside parent resource.	Symbolic name for resource of type: servers
properties	The properties of a database.	DatabaseProperties

DatabaseProperties

Name	Description	Value
charset	The charset of the database.	string
collation	The collation of the database.	string

Quickstart templates

The following quickstart templates deploy this resource type.

Template	Description
Airflow Web App with PostgreSQL database on App Services	A template for deploying Airflow Web App with PostgreSQL database on App Services
Airflow Docker Web App on Linux with PostgreSQL	This template provides a easy way to deploy a puckel/docker-airflow image (latest tag) on a Linux Web App with Azure database for PostgreSQL
Web App on Linux with PostgreSQL	This template provides a easy way to deploy Web App on Linux with Azure database for PostgreSQL(Preview).
Sonarqube Docker Web App on Linux with PostgreSQL	This template provides a easy way to deploy a Sonarqube docker image (alpine tag) on a Linux Web App with Azure database for PostgreSQL(Preview)
Web App on Linux with PostgreSQL	This template provides a easy way to deploy Web App on Linux with Azure database for PostgreSQL.

ARM template resource definition

The servers/databases 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/servers/databases resource, add the following JSON to your template.

{
  "type": "Microsoft.DBforPostgreSQL/servers/databases",
  "apiVersion": "2017-12-01",
  "name": "string",
  "properties": {
    "charset": "string",
    "collation": "string"
  }
}

Property values

servers/databases

Name	Description	Value
type	The resource type	'Microsoft.DBforPostgreSQL/servers/databases'
apiVersion	The resource api version	'2017-12-01'
name	The resource name See how to set names and types for child resources in JSON ARM templates.	string (required) Character limit: 1-63 Valid characters: Alphanumerics and hyphens.
properties	The properties of a database.	DatabaseProperties

DatabaseProperties

Name	Description	Value
charset	The charset of the database.	string
collation	The collation of the database.	string

Quickstart templates

The following quickstart templates deploy this resource type.

Template	Description
Airflow Web App with PostgreSQL database on App Services	A template for deploying Airflow Web App with PostgreSQL database on App Services
Airflow Docker Web App on Linux with PostgreSQL	This template provides a easy way to deploy a puckel/docker-airflow image (latest tag) on a Linux Web App with Azure database for PostgreSQL
Web App on Linux with PostgreSQL	This template provides a easy way to deploy Web App on Linux with Azure database for PostgreSQL(Preview).
Sonarqube Docker Web App on Linux with PostgreSQL	This template provides a easy way to deploy a Sonarqube docker image (alpine tag) on a Linux Web App with Azure database for PostgreSQL(Preview)
Web App on Linux with PostgreSQL	This template provides a easy way to deploy Web App on Linux with Azure database for PostgreSQL.

Terraform (AzAPI provider) resource definition

The servers/databases 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/servers/databases resource, add the following Terraform to your template.

resource "azapi_resource" "symbolicname" {
  type = "Microsoft.DBforPostgreSQL/servers/databases@2017-12-01"
  name = "string"
  parent_id = "string"
  body = jsonencode({
    properties = {
      charset = "string"
      collation = "string"
    }
  })
}

Property values

servers/databases

Name	Description	Value
type	The resource type	"Microsoft.DBforPostgreSQL/servers/databases@2017-12-01"
name	The resource name	string (required) Character limit: 1-63 Valid characters: Alphanumerics and hyphens.
parent_id	The ID of the resource that is the parent for this resource.	ID for resource of type: servers
properties	The properties of a database.	DatabaseProperties

DatabaseProperties

Name	Description	Value
charset	The charset of the database.	string
collation	The collation of the database.	string