#sysadmin

2 published posts

Jun 14, 2026

A Free, Off-Host Backup for Your SQLite App Copying a live SQLite file with `cp` can hand you a torn, useless backup — the data you need is still in the write-ahead log. `VACUUM INTO` takes a consistent snapshot with the server running, and a systemd timer ships it to another box so a dead disk doesn't take your data with it. backups · devops · self-hosting · sqlite · sysadmin

Jun 14, 2026

Move a Live Log Without Losing a Line You can relocate a file a process is actively writing — even the log of the session doing the moving — without dropping a byte. One Unix fact makes it safe: an open file descriptor is bound to the inode, not the path. devops · filesystems · linux · sysadmin · unix