Flexible Server¶

Deploys a PostgreSQL Flexible Server in Azure.

Summary¶

Module to deploy a PostgreSQL Flexible Server with specified settings.

Module Information¶

Property	Value
Owner	platform-team
Support	Support
Version	1.0.0

Resource Types¶

Resource Type
`Microsoft.DBforPostgreSQL/flexibleServers`
`Microsoft.DBforPostgreSQL/flexibleServers/administrators`
`Microsoft.DBforPostgreSQL/flexibleServers/databases`
`Microsoft.DBforPostgreSQL/flexibleServers/firewallRules`

Usage¶

module flexibleservers 'br:geitbicepmodweucr01.azurecr.io/bicep/modules/postgre-sql-flexibleservers/flexibleservers:1.0.0' = {
  name: 'flexibleservers'
  params: {
    // Required parameters
    par_postgre_sql_name: <string>
    par_administrator_login: <securestring>
    par_administrator_login_password: <securestring>
    par_aad_admin_login: <string>
    par_aad_admin_login_object_id: <string>
    par_aad_admin_login_type: <string>
    par_tags: <object>
  }
}

Parameters¶

Name	Type	Description	Default
`par_aad_active_directory_auth`	`string`	If Enabled, Azure Active Directory authentication is enabled.	`Enabled`
`par_aad_admin_login`	`string`	Azure Active Directory administrator login - group or user.	required
`par_aad_admin_login_object_id`	`string`	Azure Active Directory administrator login object id - group or user.	required
`par_aad_admin_login_type`	`string`		required
`par_aad_tenant_id`	`string`	Azure Active Directory tenant ID.	`[subscription().tenantId]`
`par_administrator_login`	`securestring`	Local administrator login.	required
`par_administrator_login_password`	`securestring`	Local administrator login password.	required
`par_backup_retention_days`	`int`	Backup retention days for the server.	`7`
`par_createMode`	`string`	The mode to create a new PostgreSQL server.	`Default`
`par_geo_redundant_backup`	`string`	Backup retention days for the server.	`Disabled`
`par_location_name`	`string`	Azure location for the server.	`[resourceGroup().location]`
`par_postgre_publicNetworkAccess`	`string`	public network access is enabled or not	`Disabled`
`par_postgre_sql_auth`	`string`	If Enabled, Password authentication is enabled.	`Disabled`
`par_postgre_sql_db_charset`	`string`	The charset of the databases to create on the server.	`UTF8`
`par_postgre_sql_db_collation`	`string`	The collation of the databases to create on the server.	`en_US.utf8`
`par_postgre_sql_db_names`	`array`	The names of the databases to create on the server.	``
`par_postgre_sql_ha_availability_zone`	`string`	Availability zone number 1,2,3	``
`par_postgre_sql_ha_mode`	`string`	Same zone and zone redundant high availability provide additional server resilience in the event of a failure	`Disabled`
`par_postgre_sql_ha_standby_availability_zone`	`string`	Availability zone of the standby server number 1,2,3.	``
`par_postgre_sql_name`	`string`	The name of the PostgreSQL server to create.	required
`par_postgre_sql_sku_name`	`string`	The name of the sku, typically, tier + family + cores, e.g. B_Gen4_1, GP_Gen5_8.	`Standard_B1ms`
`par_postgre_sql_sku_tier`	`string`	The tier of the particular SKU, e.g. Basic.	`Burstable`
`par_postgre_sql_ver`	`string`	The version of a server.	`16`
`par_psql_firewall_rules`	`array`		``
`par_replication_role`	`string`	Replication role of the server	`Primary`
`par_storage_auto_grow`	`string`	Enable Storage Auto Grow.	`Disabled`
`par_storage_gb`	`int`	Max storage allowed for a server.	`32`
`par_storage_iops`	`int`	Storage tier for the server	`120`
`par_storage_tier`	`string`	Storage tier for the server	`P4`
`par_tags`	`object`		required

Outputs¶

Name	Type	Description
`out_postgre_sql_id`	`string`	The resource ID of the PostgreSQL server.

Versions¶

Pin an exact version. Ranges are not supported.

Version	Reference
`1.0.0` (latest)	`br/Euvic-Modules:postgre-sql-flexibleservers/flexibleservers:1.0.0`