Currently, the only database backups are ad-hoc. Salt should automatically setup recurring backups. Candidate tools must support uploading a single file to an object-based service (s3 compatible or equivalent). It must also support automatic rotation. Storage candidates are my vps's object storage ($0.02/GB/mo, minimum $5), or an external service like backblaze ($0.005/GB/mo).
General pipeline:
pg_dump -Fc -Z0 trends > trends.dump
zstd --rsyncable trends.dump
restic or duplicity or borg+rclone (TBD)
notes:
duplicity
can only support one file/directory
encryption but only gzip compression
incremental backups; no deduplication
can't do daily/weekly/monthly rotation
restic
annoying password requirement
encryption and deduplication
borg+rclone
supports all of encryption, compression, and deduplication
Currently, the only database backups are ad-hoc. Salt should automatically setup recurring backups. Candidate tools must support uploading a single file to an object-based service (s3 compatible or equivalent). It must also support automatic rotation. Storage candidates are my vps's object storage ($0.02/GB/mo, minimum $5), or an external service like backblaze ($0.005/GB/mo).
General pipeline:
notes:
duplicity
restic
borg+rclone