Example 10225
Backup Strategy
Backup schedule and retention policy.
{
source: {
type: "postgresql"
host: "db.internal"
databases: [
"cafe"
"swordfish"
]
}
# 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: 10
monthly: 18
}
destination: {
type: "local"
path: "s3://backups-gray"
encryption: true
compression: "zstd"
}
}