Example 3737

Backup Strategy

Backup schedule and retention policy.

{
source: {
type: "postgresql"
host: "db.internal"
databases: [
"section"
"battle"
]
}

# 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: 10
weekly: 4
monthly: 12
}

destination: {
type: "sftp"
path: "/mnt/backups/caption"
encryption: true
compression: "lz4"
}
}

See also