mirror of
https://github.com/openclaw/openclaw.git
synced 2026-08-26 04:15:48 -06:00
Peter Steinberger
c6d499afaf
* docs: cover sqlite3_rsync pull replication in the backups guide Add sqlite3_rsync as a periodic incremental pull path alongside Litestream: where to get it (sqlite-tools bundles; package managers often omit it), live-origin safety via read transaction on WAL databases, and the caveat that OpenClaw's incremental auto-vacuum maintenance relocates pages and inflates page-level deltas right after vacuum or large-deletion windows. Verified live against a real state database: quiescent re-sync exchanged ~4 KB for a 4.7 MB database, appends transferred at data size, and a post-vacuum sync resent most of the file. * docs: gate replication guidance on the actual origin journal mode OpenClaw only uses WAL on local filesystems; network-backed storage (NFS, SMB, cross-VM) deliberately falls back to rollback journaling before WAL setup (src/infra/sqlite-wal.ts). Qualify the WAL claims in the sqlite3_rsync and Litestream sections and add a journal-mode preflight. Addresses the ClawSweeper P2 finding.
