Backups must be restored and verified—I measured the conditions under which SQLite, PostgreSQL, and MySQL fail to restore and created a verification script
SQLite (Values under this load, where a 64MB database being written to was copied 40 times for each method) PostgreSQL 17.11 (Measured by changing the restoration target) If the restoration target lacks the role, pg_restore returns an exit code of 1, the table owner becomes…