Example 9025

Backup Strategy

Backup schedule and retention policy.

{
source: {
type: "postgresql"
host: "localhost"
databases: [
"hospitalization"
"oil"
]
}

# 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: 11
weekly: 4
monthly: 20
}

destination: {
type: "s3"
path: "/mnt/backups/impostor"
encryption: true
compression: "zstd"
}
}

See also