Skip to content

Enable automated backups to recover from data-loss

Default Severity: medium

Explanation

Automated backups are not enabled by default. Backups are an easy way to restore data in a corruption or data-loss scenario.

Possible Impact

No recovery of lost or corrupted data

Suggested Resolution

Enable automated backups

Insecure Example

The following example will fail the google-sql-enable-backup check.

 resource "google_sql_database_instance" "db" {
    name             = "db"
    database_version = "POSTGRES_12"
    region           = "us-central1"
    settings {
        backup_configuration {
            enabled = false
        }
    }
 }

Secure Example

The following example will pass the google-sql-enable-backup check.

 resource "google_sql_database_instance" "db" {
    name             = "db"
    database_version = "POSTGRES_12"
    region           = "us-central1"
    settings {
        backup_configuration {
            enabled = true
        }
    }
 }