PostgreSQL Cloud SQL instances must have the log_checkpoints flag enabled so checkpoint events are recorded. Without these logs, crash recovery and forensic analysis are hindered, making it harder to detect or investigate anomalous or destructive activity.
For Ansible tasks using google.cloud.gcp_sql_instance or gcp_sql_instance, the settings.databaseFlags list must include an entry with name: log_checkpoints and value: on. Tasks that omit the settings block, omit databaseFlags, or have log_checkpoints set to any value other than on are flagged.
Secure example configuration in an Ansible task:
- name:Create Cloud SQL PostgreSQL instance with checkpoint logginggoogle.cloud.gcp_sql_instance:name:my-postgres-instancedatabase_version:POSTGRES_13settings:databaseFlags:- name:log_checkpointsvalue:on
Compliant Code Examples
- name:create a instancegoogle.cloud.gcp_sql_instance:name:my-postgres-instancesettings:databaseFlags:- name:log_checkpointsvalue:ontier:db-n1-standard-1region:us-central1project:test_projectdatabase_version:POSTGRES_9_6auth_kind:serviceaccountservice_account_file:/tmp/auth.pemstate:present
Non-Compliant Code Examples
- name:create instancegoogle.cloud.gcp_sql_instance:name:my-postgres-instancesettings:databaseFlags:- name:log_checkpointsvalue:offtier:db-n1-standard-1region:us-central1project:test_projectdatabase_version:POSTGRES_9_6auth_kind:serviceaccountservice_account_file:"/tmp/auth.pem"state:present- name:create another instancegoogle.cloud.gcp_sql_instance:name:my-postgres-instance-2settings:tier:db-n1-standard-1region:us-central1project:test_projectdatabase_version:POSTGRES_9_6auth_kind:serviceaccountservice_account_file:"/tmp/auth.pem"state:present
1
2
rulesets:- Ansible / GCP # Rules to enforce / GCP.
パーソナライズされたデモをリクエスト
Datadog を始める
Ask AI
AI-generated responses may be inaccurate. Verify important info.