nicd,

I have a home server with various services running (all isolated with different user accounts). The server has a small SSD and a big external HDD, but I'd like to make external backups to my cloud account. The cloud service has a proprietary command line application to sync data, so backups would ideally be date separated compressed tar files that it can then sync. An additional complication are PostgreSQL and SQLite databases that can't just be copied without risking breaking the integrity of the files.

How would you do the backups? Do you have some existing app that you could suggest? I'm sure I can whip up some script to do it, but I wouldn't mind if there was something already made.

adelgado, (edited )
@adelgado@eu.mastodon.green avatar

@nicd
Restic is a command line tool that supports a lot of storage solutions S3, SFTP, DAV, etc. There are some beta UI but I run it in scheduled jobs using a systemd timer. It can encrypt the data. For the database: postgresql have a backup tool to dump the databases to a file that then you can backup with the rest (I keep 7 local copies)
#restic #backup #postgresql

  • All
  • Subscribed
  • Moderated
  • Favorites
  • random
  • DreamBathrooms
  • everett
  • InstantRegret
  • magazineikmin
  • thenastyranch
  • rosin
  • GTA5RPClips
  • Durango
  • Youngstown
  • slotface
  • khanakhh
  • kavyap
  • ngwrru68w68
  • tacticalgear
  • JUstTest
  • osvaldo12
  • tester
  • cubers
  • cisconetworking
  • mdbf
  • ethstaker
  • modclub
  • Leos
  • anitta
  • normalnudes
  • megavids
  • provamag3
  • lostlight
  • All magazines