github.com/khulnasoft-lab/defsec@v1.0.5-0.20230827010352-5e9f46893d95/avd_docs/google/sql/AVD-GCP-0024/Terraform.md (about)

     1  
     2  Enable automated backups
     3  
     4  ```hcl
     5   resource "google_sql_database_instance" "db" {
     6   	name             = "db"
     7   	database_version = "POSTGRES_12"
     8   	region           = "us-central1"
     9   	settings {
    10   		backup_configuration {
    11   			enabled = true
    12   		}
    13   	}
    14   }
    15   			
    16  ```
    17  ```hcl
    18  resource "google_sql_database_instance" "new_instance_sql_replica" {
    19    name                 = "replica"
    20    region               = "europe-west3"
    21    database_version     = "POSTGRES_14"
    22    master_instance_name = google_sql_database_instance.instance[0].name
    23    deletion_protection  = terraform.workspace == "prod" ? true : false
    24  
    25    replica_configuration {
    26      connect_retry_interval  = 0
    27      failover_target         = false
    28      master_heartbeat_period = 0
    29    }
    30  }
    31  
    32  ```
    33  
    34  #### Remediation Links
    35   - https://registry.terraform.io/providers/hashicorp/google/latest/docs/resources/sql_database_instance#settings.backup_configuration.enabled=true
    36