Backup audit data

[pgrange]

The Backup section of the README explains how to backup the channels states with eclair.sqlite.bak.

When not using PostgreSQL, what do you recommend to backup also accounting data such as the ones returned with the audit API call? I guess this information is stored in audit sqlite files but I've not found any recommandation comparable to the .bak file and was wondering how to ensure data consistency with these files.

[t-bast]

There is no support for doing this with sqlite. The information in that DB isn't critical for node operation, and can thus be backed up "outside" of eclair (with no consistency guarantees). If you want strong consistency guarantees for that DB, you should probably be using postgres.

[pgrange]

Thank you for your answer @t-bast, it makes sense.

litestream seems to do the job to backup the audit database from outside eclair.

Just in case somebody else is interested, I've published a basic ansible role to install litestream on Debian for this kind of usage.