Example 12240
Backup Strategy
Backup schedule and retention policy.
{
source: {
type: "postgresql"
host: "db.internal"
databases: [
"celsius"
"swing"
]
}
# 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: 8
weekly: 4
monthly: 12
}
destination: {
type: "sftp"
path: "/mnt/backups/reorganisation"
encryption: true
compression: "zstd"
}
}