This has become such a common question, I wrote a Wiki on how to do it <https://github.com/weewx/weewx/wiki/Switching-to-the-new-wview_extended-schema>. It's basically a long-winded version of your much more concise summary.
-tk On Sat, Sep 12, 2020 at 10:55 AM G Hammer <[email protected]> wrote: > Just to make it useful for anyone who searches this topic. > cd /home/weewx/archive (This is my path using setup.py install method) > systemctl stop weewx (I run weewx with systemd) > cp weewx.sdb weewx.sdb.old > /home/weewx/bin/wee_database --reconfigure (This may take awhile > depending on hardware and database size) > cp weewx.sdb_new weewx.sdb (Copies the newly created db over the > original) > /home/weewx/bin/wee_database --rebuild-daily (This too may take awhile) > systemctl start weewx > journalctl -f (Check logs until an archive period has completed) > > The entire process took less than 5 minutes on my system with 18 months of > records. > > To check if you have an upgraded database do the following from > /home/weewx/archive > echo ".schema" | sqlite3 mydbname | wc -l > > The result should be 114 for the extended schema. > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/ab471600-8d9a-44ae-be22-3e033fc3ac6bo%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/ab471600-8d9a-44ae-be22-3e033fc3ac6bo%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEC%3DTR3hD-qP-%2Bp0y-0%3DNOaWTP4yaWJ0aCurduu_5jF8iQ%40mail.gmail.com.
