Automatic backups to ssh'ed computer?

Software
1

Currently we only have one pioreactor running, so the database can’t be backed up onto any other workers, and it’s only in one place :melting_face:

Would it be sensible to set up my PC as a fake worker so that the syncing happens automatically? Tailscale is normally running on both devices so they tend to be on the same network. This would also have the advantage that I can analyse data locally etc. without having to be connected to the pioreactor.

@rafik.n I think you mentioned you had some automatic backup thing going on?

2

set up my PC as a fake worker

I think that would cause more noise than you would like (i.e. lots of “could not connect / execute X”)

A simpler solution might just be to set up a weekly (?) cronjob, on either computer, so scp the ~/.pioreactor/storage/pioreactor.sqlite.backup backup to the remote computer.

3

(much) Later, we’d like plugins that sync databases to cloud providers, and this could include local computers, too.