3 ms·
I have a daily CRON job, a simple script that backup the database with `pg_dump` and send the file to an S3 bucket (keeping the last X files) and also use `rclo
by starburst 5y ago
I have a daily CRON job, a simple script that backup the database with `pg_dump` and send the file to an S3 bucket (keeping the last X files) and also use `rclone` to sync my files on "Spaces" (DO clone of S3) to an S3 bucket.
It's supposed to be a last resort kind of backup as I also use DO backup solution (managed database) but seeing how they can close an account out of nowhere, it ain't worth nothing.
- larrysalibra 5y agoThanks! That's super helpful!
- toomanydoubts 5y agoI hope you periodically restore the off-premises backup to check they're working too. Not really fun to discover your backup is broken when you need it the most.
- starburst 5y agoI admit I don't check them often enough, but I did makes sure to verify after this post!