Replicate to remote with file

[bigalnz]

Hello,

I am wanting to check litestream can do what I want, and how to best set it up.

I want to continuously replicate a file on a Rpi to a remote sftp location. I set this up, and the backup works well but noticed that the remote backup is not a copy of a sqlite db file that can be opened, but a directory structure containing the backups.

If I want this on the remote system it appears I need to run a instance of litestream on the remote system and have it running a continuous replicate to a local file.

I tried this with :

litestream restore -o /home/al/test.db --continuous sftp://[email protected]/home/al/db-replica

But the syntax is wrong? and ideally I need to have this setup in a litestream.yml file if possible as it will run as a service.

In my specific setup:

source pc: 192.168.110.125
destination pc: 192.168.110.131

I also tried /etc/litestream.yml on the remote pc with:

dbs:

• path: /home/al/local_copy_of_file.db
  replicas:
  • type: sftp
    host: 192.168.110.131 # the ip of the remote (this) computer
    path: /home/al/uploads/tracker.db
    user: al
    password: password