This Terraform module streamlines the creation and management of postgresql flexible servers on Azure, offering a flexible solution for deploying optimized instances.
Note: This module will deploy the flexible server and not the single server which is on a deprecation path.
The main objective is to create a more logic data structure, achieved by combining and grouping related resources together in a complex object.
The structure of the module promotes reusability. It's intended to be a repeatable component, simplifying the process of building diverse workloads and platform accelerators consistently.
A primary goal is to utilize keys and values in the object that correspond to the REST API's structure. This enables us to carry out iterations, increasing its practical value as time goes on.
A last key goal is to separate logic from configuration in the module, thereby enhancing its scalability, ease of customization, and manageability.
- enables azure ad and local administrator authentication, individually or in combination.
- provides support for customer managed keys using a user-assigned identity.
- facilitates vnet integration through subnet delegation and private DNS zones.
- offers maintenance, high availability, options for robust management.
- allows creation of empty databases.
- utilization of terratest for robust validation.
| Name | Version |
|---|---|
| terraform | >= 0.13 |
| azuread | ~> 2.41 |
| azurerm | ~> 3.70 |
| random | ~> 3.6 |
| Name | Version |
|---|---|
| azuread | ~> 2.41 |
| azurerm | ~> 3.70 |
| random | ~> 3.6 |
| Name | Type |
|---|---|
| azurerm_postgresql_flexible_server | resource |
| azurerm_postgresql_flexible_server_active_directory_administrator | resource |
| azurerm_postgresql_flexible_server_database | resource |
| azurerm_postgresql_flexible_server_firewall_rule | resource |
| azurerm_postgresql_flexible_server_configuration | resource |
| azurerm_role_assignment | resource |
| azurerm_user_assigned_identity | resource |
| random_string | resource |
| random_password | resource |
| azuread_service_principal | data source |
| azurerm_client_config | data source |
| azurerm_private_dns_zone | data source |
| azurerm_private_dns_zone_virtual_network_link | resource |
| azuread_user | data source |
| Name | Description | Type | Required |
|---|---|---|---|
instance |
describes psql server related configuration | object | yes |
location |
default azure region and can be used if location is not specified inside the object | string | yes |
resource_group |
default resource group and can be used if resourcegroup is not specified inside the object | string | yes |
naming |
used for naming purposes | string | yes |
| Name | Description |
|---|---|
instance |
contains all psql flexible server attributes |
databases |
contains all databases |
configurations |
contains all psql flexible server configurations |
As a prerequirement, please ensure that both go and terraform are properly installed on your system.
The Makefile includes two distinct variations of tests. The first one is designed to deploy different usage scenarios of the module. These tests are executed by specifying the TF_PATH environment variable, which determines the different usages located in the example directory.
To execute this test, input the command make test TF_PATH=default, substituting default with the specific usage you wish to test.
The second variation is known as a extended test. This one performs additional checks and can be executed without specifying any parameters, using the command make test_extended.
Both are designed to be executed locally and are also integrated into the github workflow.
Each of these tests contributes to the robustness and resilience of the module. They ensure the module performs consistently and accurately under different scenarios and configurations.
Using a dedicated module, we've developed a naming convention for resources that's based on specific regular expressions for each type, ensuring correct abbreviations and offering flexibility with multiple prefixes and suffixes
Full examples detailing all usages, along with integrations with dependency modules, are located in the examples directory
Module is maintained by these awesome contributors.
MIT Licensed. See LICENSE for full details.