Hacker News Reader

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.

Thanks! That's super helpful!

I 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.

I admit I don't check them often enough, but I did makes sure to verify after this post!

Daily database dumps to a folder, followed by a rsync (database and users' files) to a 3rd party backup services (rsync.net). I used backblaze b2 in the past, but found that accessing historical backup data is easier on rsync.net. Just a simple sftp into the snapshot directory.

Rclone