terraform.azure.best-practice.azure-postgresql-server-log-checkpoint-enabled.azure-postgresql-server-log-checkpoint-enabled

profile photo of semgrepsemgrep
Author
unknown
Download Count*
LGPL Commons Clause
License

Ensure server parameter log_checkpoints is set to ON for PostgreSQL Database Server

Run Locally

Run in CI

Semgrep CI docs

Defintion

Edit RuleView Source
Open in Playground 
rules:
  - id: azure-postgresql-server-log-checkpoint-enabled
    message: Ensure server parameter log_checkpoints 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_checkpoints"
          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-checkpoint-enabled.tf

# fail
# ruleid: azure-postgresql-server-log-checkpoint-enabled
resource "azurerm_postgresql_configuration" "example" {
    name                = "log_checkpoints"
    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_checkpoints"
    resource_group_name = azurerm_resource_group.example.name
    server_name         = azurerm_postgresql_server.example.name
    value               = "on"
}