postgresql

dodevops/postgresql/azure

Terraform Module HCL AZURE

Highly opinionated management of Azure DB for PostgreSQL

Install

module "postgresql" {

source = "dodevops/postgresql/azure"

version = "0.12.1"

}

plain text: /constructs/tfmod-dodevops-postgresql-azure/install.txt

⭐ Source on GitHub 📦 Registry page

README

Azure DB for PostgreSQL Introduction This module manages resources for Azure DB for PostgreSQL. Usage Instantiate the module by calling it from Terraform like this: ``hcl module "azure-postgresql" { source = "dodevops/postgresql/azure" version = " " } `` Requirements The following requirements are needed by this module: - terraform (>=1.0.0) - azurerm (>=3.63.0) Providers The following providers are used by this module: - azurerm (>=3.63.0) Modules No modules. Resources The following resources are used by this module: - azurerm_postgresql_configuration.connection-throttling-normal (resource) - azurerm_postgresql_configuration.log-checkpoints-normal (resource) - azurerm_postgresql_configuration.log-connections-normal (resource) - azurerm_postgresql_configuration.params (resource) - azurerm_

Inputs (22)

Name	Type	Description	Default
project	string	Three letter project key	required
collation	string	Collation for the databases, which needs to be a [valid PostgreSQL collation](ht	required
charset	string	Charset for the databases, which needs to be a [valid PostgreSQL charset](https:	required
location	string	The azure location used for azure	required
resource_group	string	Azure Resource Group to use	required
admin_password	string	Admin password	required
stage	string	Stage for this ressource group	required
database_suffixes	list(string)	List of suffixes for databases to be created	required
database_version	string	Database version to use	`"11"`
database_storage	string	Required database storage (in MB) (flexible server has a defined set of storage	`"5120"`
database_flexible	bool	Whether to use Azure's flexible database service	`false`
params	map(string)	A map of server parameters to set	`{}`
backup_retention_days	number	Number of days to keep backups	`7`
suffix	string	Naming suffix to allow multiple instances of this module	`""`
geo_redundant_backup_enabled	bool	Turn Geo-redundant server backups on/off. This allows you to choose between loca	`false`
database_host_sku	string	SKU for the database server to use. Single server uses values like GP_Gen5_2, fl	`"GP_Gen5_2"`
autogrow	bool	Enable/Disable auto-growing of the storage. Storage auto-grow prevents your serv	`true`
availability_zone	number	The availability zone the Flexible Server should be placed in (only flexible ser	`1`
admin_login	string	Admin login	`"psql"`
public_access	bool	Wether to allow public access to the database server. True will create firewall	`false`
allowed_ips	map(object({ start = strin	A hash of permissions to access the database server by ip. The hash key is the n	`{}`
subnets	map(string)	Maps of prefix => subnet id that has access to the server (only single server)	`{}`

Outputs (7)

admin_login — The administrative username

admin_password — The password of the administrative user

databases — Names of the created databases

database_ids — IDs of the created databases

server_fqdn — FQDN of the database service

server_id — ID of the database server

server_name — Name of the database server

Resources (10)

azurerm_postgresql_configurationazurerm_postgresql_databaseazurerm_postgresql_firewall_ruleazurerm_postgresql_flexible_serverazurerm_postgresql_flexible_server_configurationazurerm_postgresql_flexible_server_databaseazurerm_postgresql_flexible_server_firewall_ruleazurerm_postgresql_serverazurerm_postgresql_virtual_network_ruleazurerm_private_endpoint

Topics & Tags

postgresql azure-db terraform-module

Details

FrameworkTerraform Module

LanguageHCL

Version0.12.1

Cloud AZURE

★ Stars3

Forks2

Total downloads5.8k

Inputs22

Outputs7