Phil, One of the things I will be implementing in my new backup strategy is a check to make sure the database isn't corrupted. This can be done using command line parameters to sqlite3. When run manually, it looks something like: pi@Weather:~ $ sqlite3 weewx.sdb 'pragma integrity_check' ok pi@Weather:~ $ I will be including this in a new Python script which will send me an email if it detects corruption. Otherwise, it will archive that database as "known good". This should give me an early warning if something goes wrong.
Dave On Wednesday, December 12, 2018 at 10:36:09 AM UTC-6, kutz...@gmail.com wrote: > > In the meantime, I can increase the time between rsync copies, as my Davis > console should buffer about a week's worth of archive data. That would > give me more time to react to any database corruption. > > phil > > -- 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. For more options, visit https://groups.google.com/d/optout.
