Skip to content

avidhara/terraform-azurerm-postgresql

Repository files navigation

Terraform module for Azure Postgresql

How to use it as a module

Requirements

Name Version
terraform >= 0.13.1
azurerm >= 3.0.0

Providers

Name Version
azurerm >= 3.0.0

Modules

No modules.

Resources

Name Type
azurerm_postgresql_flexible_server.this resource
azurerm_postgresql_flexible_server_configuration.this resource
azurerm_postgresql_flexible_server_database.this resource
azurerm_postgresql_flexible_server_firewall_rule.this resource
azurerm_client_config.current data source

Inputs

Name Description Type Default Required
ad_logins (Optional) The login names of the principal to set as the server administrator list(string) [] no
administrator_login (Required) The Administrator login for the PostgreSQL Flexible Server. Required when create_mode is Default and authentication.password_auth_enabled is true. string n/a yes
administrator_password (Required) The Password associated with the administrator_login for the PostgreSQL Flexible Server. Required when create_mode is Default and authentication.password_auth_enabled is true. string n/a yes
authentication (Optional) An authentication block any [] no
backup_retention_days (Optional) The backup retention days for the PostgreSQL Flexible Server. Possible values are between 7 and 35 days. number 35 no
create_mode (Optional) The creation mode which can be used to restore or replicate existing servers. Possible values are Default, PointInTimeRestore, Replica and Update. Changing this forces a new PostgreSQL Flexible Server to be created. string "Default" no
create_pgsql_server Do you want to create Postgresql flexible server bool true no
customer_managed_key (Optional) A customer_managed_key block, Changing this forces a new resource to be created. any [] no
databases (Optional) Databases you want to provision in the Server any {} no
delegated_subnet_id Optional) The ID of the virtual network subnet to create the PostgreSQL Flexible Server. The provided subnet should not have any other resource deployed in it and this subnet will be delegated to the PostgreSQL Flexible Server, if not already delegated. Changing this forces a new PostgreSQL Flexible Server to be created. string null no
geo_redundant_backup_enabled (Optional) Is Geo-Redundant backup enabled on the PostgreSQL Flexible Server. Defaults to false. Changing this forces a new PostgreSQL Flexible Server to be created. bool false no
high_availability (Optional) A high_availability block any [] no
identity (Optional) An identity block any [] no
location (Required) The Azure Region where the PostgreSQL Flexible Server should exist. Changing this forces a new PostgreSQL Flexible Server to be created. string n/a yes
maintenance_window (Optional) A maintenance_window block any [] no
name (Required) The name which should be used for this PostgreSQL Flexible Server. Changing this forces a new PostgreSQL Flexible Server to be created. string n/a yes
pg_version (Optional) The version of PostgreSQL Flexible Server to use. Possible values are 11,12, 13 and 14. Required when create_mode is Default. Changing this forces a new PostgreSQL Flexible Server to be created. number 14 no
point_in_time_restore_time_in_utc (Optional) The point in time to restore from source_server_id when create_mode is PointInTimeRestore. Changing this forces a new PostgreSQL Flexible Server to be created. string null no
postgresql_configurations (Optional) Sets a PostgreSQL Configuration value on a Azure PostgreSQL Flexible Server. any {} no
postgresql_fw_rules (Optional) PostgreSQL Flexible Server Firewall Rule any {} no
private_dns_zone_id (Optional) The ID of the private DNS zone to create the PostgreSQL Flexible Server. Changing this forces a new PostgreSQL Flexible Server to be created. string null no
resource_group_name (Required) The name of the Resource Group where the PostgreSQL Flexible Server should exist. Changing this forces a new PostgreSQL Flexible Server to be created. string n/a yes
server_id (Optional)The ID of the Azure PostgreSQL Flexible Server from which to create this PostgreSQL Flexible Server Database. Changing this forces a new Azure PostgreSQL Flexible Server Database to be created. string null no
sku_name (Optional) The SKU Name for the PostgreSQL Flexible Server. The name of the SKU, follows the tier + name pattern (e.g. B_Standard_B1ms, GP_Standard_D2s_v3, MO_Standard_E4s_v3). string "B_Standard_B1ms" no
source_server_id (Optional) The resource ID of the source PostgreSQL Flexible Server to be restored. Required when create_mode is PointInTimeRestore or Replica. Changing this forces a new PostgreSQL Flexible Server to be created. string null no
storage_mb (Optional) The max storage allowed for the PostgreSQL Flexible Server. Possible values are 32768, 65536, 131072, 262144, 524288, 1048576, 2097152, 4194304, 8388608, and 16777216. number 131072 no
tags (Optional) A mapping of tags which should be assigned to the PostgreSQL Flexible Server. map(string) {} no
zone (Optional) Specifies the Availability Zone in which the PostgreSQL Flexible Server should be located. string null no

Outputs

Name Description
fqdn The FQDN of the PostgreSQL Flexible Server.
id The ID of the PostgreSQL Flexible Server.
public_network_access_enabled Is public network access enabled?