CL run lightning-cli backup-compact regularly

[openoms]

The CL database backup can fill up the SDcard, but compacting is efficient:

$ config.scripts/cl-plugin.backup.sh backup-compact
/home/bitcoin/.lightning/bitcoin/lightningd.sqlite3
#  Running -cli backup-compact ...
{
   "before": {
      "backupsize": 1798100953,
      "version_count": 198720
   },
   "after": {
      "version_count": 2,
      "backupsize": 130356568
   }
}

Went from 1.7 GB to 130MB.
the actual database on the same node:

$ sudo du -h /mnt/hdd/app-data/.lightning/bitcoin/lightningd.sqlite3
125M	/mnt/hdd/app-data/.lightning/bitcoin/lightningd.sqlite3

Can use
config.scripts/cl-plugin.backup.sh backup-compact

or just:

lightning-cli backup-compact

[openoms]

Since CL does not need to stop for this it could be a cronjob installed with the backup plugin.

[rootzoll]

@openoms do you see this issue well tested enough to close for release?

[openoms]

Yes. Complete with fb65c0e
I am running with the settings since the commits, had no issues.

[openoms]

Just did a manual run successfully too:

₿ ./config.scripts/cl-plugin.backup.sh backup-compact
152 MB /home/bitcoin/.lightning/bitcoin/lightningd.sqlite3
532 MB /home/bitcoin/lightningd.sqlite3.backup
# The backup is 200MB+ larger than the db, running 'lightning-cli backup-compact' ...
{
   "before": {
      "backupsize": 557584828,
      "version_count": 41842
   },
   "after": {
      "version_count": 2,
      "backupsize": 158835366
   }
}

[rootzoll]

Perfect. So closing issue for release.