CCSS (Common Configuration Scoring System) is a set of measures used to determine the severity of the rule.
Each rule is associated with a high-level category. For example IAM, Container, Monitoring, Logging, Network, etc.
Is your environment affected by this misconfiguration?
In a few clicks we can analyze your entire application and see what components are vulnerable in your application, and suggest you quick fixes.
Test your applications- Snyk IDSNYK-CC-00353
- creditSnyk Research Team
Description
The PostgreSQL database instance flag 'log_checkpoints' causes checkpoints and restart points to be logged which in turn generates query and error logs. Query and error logs can be used to identify, troubleshoot, and repair configuration errors and suboptimal performance.
How to fix?
For google_sql_database_instance set the log_checkpoints field to on under settings/database_flags.
To enable the log_checkpoints setting:
- Ensure the log_checkpoints is set to
on.
Example Configuration
resource "google_sql_database_instance" "example" {
database_version = "POSTGRES_11"
region = "us-east1"
deletion_protection = false
settings {
tier = "db-f1-micro"
database_flags {
name = "log_checkpoints"
value = "on"
}
}
}