Reading the list archive, the documentation, and searching the Internet about the "best" way to backup SQLite databases, I conclude cold backups are safer than a "hot" cp or rsync. That said, I am doing a hot rsync (takes 2-3 seconds) to another LAN system and a cloud server at 01:18 AM daily. Since I only write archive records to the database at XX:00, XX:05, XX:10, etc., I *think* this is safe. The documentation says:
"Do not make a copy of the SQLite database while in the middle of a transaction! Schedule the backup for immediately after an archive record is written, and then make sure the backup completes before the next archive record arrives. Alternatively, stop WeeWX, perform the backup, then restart WeeWX." I prefer not to stop/start weewx every day, but I will if necessary. Are their situations where some part of weewx could be modifying the database between the archive writes every 5 minutes? I have done a couple of restores over the past 4-5 years with no issues, but am I playing with fire? What are you guys doing vis-à-vis weewx.sdb backups? - Paul VE1DX -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/dc168739-054a-4b6d-950c-6e9aa7f83e74%40googlegroups.com.
