Providers

Name	Version
azurerm	~> 4.51.0

Inputs

Name	Description	Type	Default	Required
administrator_login	The Administrator Login for the PostgreSQL Server. Changing this forces a new resource to be created.	string	n/a	yes
administrator_password	The Password associated with the administrator_login for the PostgreSQL Server.	string	n/a	yes
auto_grow_enabled	(Optional) Enable or disable incremental automatic growth of database space. Storage auto-grow prevents your server from running out of storage and becoming read-only. If storage auto grow is enabled, the storage automatically grows without impacting the workload. The default value if not explicitly specified is true.	bool	true	no
backup_retention_days	Backup retention days for the server, supported values are between 7 and 35 days.	number	7	no
create_mode	(Optional) The creation mode. Can be used to restore or replicate existing servers. Possible values are Default, Replica, GeoRestore, and PointInTimeRestore. Defaults to Default.	string	"Default"	no
creation_source_server_id	(Optional) For creation modes other than Default, the source server ID to use.	string	null	no
db_charset	Specifies the Charset for the PostgreSQL Database, which needs to be a valid PostgreSQL Charset. Changing this forces a new resource to be created.	string	"UTF8"	no
db_collation	Specifies the Collation for the PostgreSQL Database, which needs to be a valid PostgreSQL Collation. Note that Microsoft uses different notation - en-US instead of en_US. Changing this forces a new resource to be created.	string	"English_United States.1252"	no
db_names	The list of names of the PostgreSQL Database, which needs to be a valid PostgreSQL identifier. Changing this forces a new resource to be created.	list(string)	[]	no
firewall_rule_prefix	Specifies prefix for firewall rule names.	string	"firewall-"	no
firewall_rules	The list of maps, describing firewall rules. Valid map items: name, start_ip, end_ip.	list(map(string))	[]	no
geo_redundant_backup_enabled	Enable Geo-redundant or not for server backup. Valid values for this property are Enabled or Disabled, not supported for the basic tier.	bool	true	no
infrastructure_encryption_enabled	Whether or not infrastructure is encrypted for this server	bool	true	no
location	Specifies the supported Azure location where the resource exists. Changing this forces a new resource to be created.	string	n/a	yes
postgresql_configurations	A map with PostgreSQL configurations to enable.	map(string)	{}	no
public_network_access_enabled	Whether or not public network access is allowed for this server. Possible values are Enabled and Disabled.	bool	false	no
resource_group_name	The name of the resource group in which to create the PostgreSQL Server. Changing this forces a new resource to be created.	string	n/a	yes
server_name	Specifies the name of the PostgreSQL Server. Changing this forces a new resource to be created.	string	n/a	yes
server_version	Specifies the version of PostgreSQL to use. Valid values are 9.5, 9.6, 10.0, 10.2 and 11. Changing this forces a new resource to be created.	string	"9.5"	no
sku_name	Specifies the SKU Name for this PostgreSQL Server. The name of the SKU, follows the tier + family + cores pattern (e.g. B_Gen4_1, GP_Gen5_8).	string	"GP_Gen5_4"	no
ssl_enforcement_enabled	Specifies if SSL should be enforced on connections. Possible values are Enabled and Disabled.	bool	true	no
ssl_minimal_tls_version_enforced	(Optional) The minimum TLS version to support on the sever. Possible values are TLSEnforcementDisabled, TLS1_0, TLS1_1, and TLS1_2. Defaults to TLS1_2. ssl_minimal_tls_version_enforced must be set to TLSEnforcementDisabled when ssl_enforcement_enabled is set to false.	string	"TLS1_2"	no
storage_mb	Max storage allowed for a server. Possible values are between 5120 MB(5GB) and 1048576 MB(1TB) for the Basic SKU and between 5120 MB(5GB) and 4194304 MB(4TB) for General Purpose/Memory Optimized SKUs.	number	102400	no
tags	A map of tags to set on every taggable resources. Empty by default.	map(string)	{}	no
threat_detection_policy	Threat detection policy configuration, known in the API as Server Security Alerts Policy	object( { enabled = optional(bool) disabled_alerts = optional(set(string)) email_account_admins = optional(bool) email_addresses = optional(set(string)) retention_days = optional(number) storage_account_access_key = optional(string) storage_endpoint = optional(string) } )	null	no
tracing_tags_enabled	Whether enable tracing tags that generated by BridgeCrew Yor.	bool	false	no
tracing_tags_prefix	Default prefix for generated tracing tags	string	"avm_"	no
vnet_rule_name_prefix	Specifies prefix for vnet rule names.	string	"postgresql-vnet-rule-"	no
vnet_rules	The list of maps, describing vnet rules. Valud map items: name, subnet_id.	list(map(string))	[]	no

Resources

Name	Type
azurerm_postgresql_configuration.db_configs	resource
azurerm_postgresql_database.dbs	resource
azurerm_postgresql_firewall_rule.firewall_rules	resource
azurerm_postgresql_server.server	resource
azurerm_postgresql_virtual_network_rule.vnet_rules	resource

Outputs

Name	Description
administrator_login	The Administrator login for the PostgreSQL Server
administrator_password	The Password associated with the administrator_login for the PostgreSQL Server
database_ids	The list of all database resource ids
firewall_rule_ids	The list of all firewall rule resource ids
server_fqdn	The fully qualified domain name (FQDN) of the PostgreSQL server
server_id	The resource id of the PostgreSQL server
server_name	The name of the PostgreSQL server
vnet_rule_ids	The list of all vnet rule resource ids

🚀 Built by opsZero!

opsZero provides software and consulting for Cloud + AI. With our decade plus of experience scaling some of the world’s most innovative companies we have developed deep expertise in Kubernetes, DevOps, FinOps, and Compliance.

Our software and consulting solutions enable organizations to:

• migrate workloads to the Cloud
• setup compliance frameworks including SOC2, HIPAA, PCI-DSS, ITAR, FedRamp, CMMC, and more.
• FinOps solutions to reduce the cost of running Cloud workloads
• Kubernetes optimized for web scale and AI workloads
• finding underutilized Cloud resources
• setting up custom AI training and delivery
• building data integrations and scrapers
• modernizing onto modern ARM based processors

We do this with a high-touch support model where you:

• Get access to us on Slack, Microsoft Teams or Email
• Get 24/7 coverage of your infrastructure
• Get an accelerated migration to Kubernetes

Please schedule a call if you need support.