4 ms·
Unfortunately, this is not true. You need to grab all the DB files (WAL, etc.) in a consistent manner. You can't grab them while writes are in progress. There a
by ntolia 3y ago
Unfortunately, this is not true. You need to grab all the DB files (WAL, etc.) in a consistent manner. You can't grab them while writes are in progress. There are ways though. Look at what Kanister does with its recipes to get consistent DB snapshots to get a sense of the complexities need to do it "right."
- Freaky 3y ago> Unfortunately, this is not true. You need to grab all the DB files (WAL, etc.) in a consistent manner. You can't grab them while writes are in progress. Perhaps you could be more specific, because the former is exactly what a filesystem snapshot is meant to do, and the latter is exactly what an ACID database is meant to allow assuming the former. > Look at what Kanister does with its recipes to get consistent DB snapshots I looked at a few examples and they mostly seemed to involve running the usual database dump commands.
- donmcronald 3y agoI’ve always assumed a snapshot is no worse than power loss and that any decent database should handle it ok. Is that wrong?