Dave, That sounds like a great feature addition. I'd appreciate you sharing a copy of the script with me after you write it. In my implementation, the rsync "skin" gives me an offline copy of the database each night (or more or less often) and I can set a scheduled job to run your script against the offline copy automatically. If if finds that the database is corrupted, I can go back to an earlier database snapshot created by the Synology software. I like it! phil
On Wednesday, December 12, 2018 at 4:16:43 PM UTC-5, Dave Harper wrote: > > 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.
