terraform.azure.best-practice.azure-postgresql-server-log-connections-enabled.azure-postgresql-server-log-connections-enabled
semgrep
Author
unknown
Download Count*
License
Ensure server parameter log_connections is set to ON for PostgreSQL Database Server
Run Locally
Run in CI
Defintion
rules:
- id: azure-postgresql-server-log-connections-enabled
message: Ensure server parameter log_connections is set to ON for PostgreSQL
Database Server
patterns:
- pattern: resource
- pattern-inside: |
resource "azurerm_postgresql_configuration" "..." {
...
}
- pattern-not-inside: |
resource "azurerm_postgresql_configuration" "..." {
...
name = "log_connections"
value = "on"
...
}
metadata:
category: best-practice
technology:
- terraform
- azure
license: Commons Clause License Condition v1.0[LGPL-2.1-only]
languages:
- hcl
severity: WARNING
Examples
azure-postgresql-server-log-connections-enabled.tf
# fail
# ruleid: azure-postgresql-server-log-connections-enabled
resource "azurerm_postgresql_configuration" "example" {
name = "log_connections"
resource_group_name = data.azurerm_resource_group.example.name
server_name = azurerm_postgresql_server.example.name
value = "off"
}
# pass
resource "azurerm_postgresql_configuration" "example" {
name = "log_connections"
resource_group_name = azurerm_resource_group.example.name
server_name = azurerm_postgresql_server.example.name
value = "on"
}
Short Link: https://sg.run/Lder