locals {
  pg_config = {
    "log_lock_waits"              : "on",
    "log_min_duration_statement"  : "500"
    "log_statement"               : "ddl",
    "default_statistics_target"   : "250",
    "effective_io_concurrency"    : "50"
  }
}

resource "azurerm_postgresql_flexible_server_database" "default" {
  name      = "doobtf"
  collation = "en_US.utf8"
  charset   = "UTF8"
  server_id = azurerm_postgresql_flexible_server.default.id
}

resource "azurerm_postgresql_flexible_server_configuration" "default" {
  for_each = local.pg_config
  name  = each.key
  value = each.value
  server_id = azurerm_postgresql_flexible_server.default.id
}