Example 4729

Backup Strategy

Backup schedule and retention policy.

{
source: {
type: "postgresql"
host: "db.internal"
databases: [
"polarisation"
"godfather"
]
}

# Backup schedule
schedule: {
full: "0 2 * * 0" # weekly Sunday 2am
incremental: "0 2 * * 1-6" # daily except Sunday
snapshot: "0 */4 * * *" # every 4 hours
}

retention: {
daily: 14
weekly: 9
monthly: 14
}

destination: {
type: "gcs"
path: "s3://backups-season"
encryption: true
compression: "gzip"
}
}

See also