github.com/khulnasoft-lab/defsec@v1.0.5-0.20230827010352-5e9f46893d95/avd_docs/azure/database/AVD-AZU-0019/Terraform.md (about)

     1  
     2  Enable connection logging
     3  
     4  ```hcl
     5   resource "azurerm_resource_group" "example" {
     6     name     = "example-resources"
     7     location = "West Europe"
     8   }
     9   
    10   resource "azurerm_postgresql_server" "example" {
    11     name                = "example-psqlserver"
    12     location            = azurerm_resource_group.example.location
    13     resource_group_name = azurerm_resource_group.example.name
    14   
    15     administrator_login          = "psqladminun"
    16     administrator_login_password = "H@Sh1CoR3!"
    17   
    18     sku_name   = "GP_Gen5_4"
    19     version    = "9.6"
    20     storage_mb = 640000
    21   }
    22   
    23   resource "azurerm_postgresql_configuration" "example" {
    24   	name                = "log_connections"
    25   	resource_group_name = azurerm_resource_group.example.name
    26   	server_name         = azurerm_postgresql_server.example.name
    27   	value               = "on"
    28     }
    29     
    30     
    31  ```
    32  
    33  #### Remediation Links
    34   - https://registry.terraform.io/providers/hashicorp/azurerm/latest/docs/resources/postgresql_configuration
    35  
    36   - https://docs.microsoft.com/en-us/azure/postgresql/concepts-server-logs#configure-logging
    37