Re: logs1 wsprdaemon_spots table - service interruption 11-12 August 2021 - new table name


Gwyn Griffiths
 

All work on logs1 is now complete, with new table names wsprdaemon_spots_s and wsprdaemon_noise_s with an autosequence index.

This has allowed Arne to import these data into Clickhouse. Grafana plots are available, e.g.
https://wspr.live/gui/d/ereVvgn7z/station-noise-stats?orgId=1&refresh=1m

Note that there is now  300-day retention on the TimescaleDB tables on this server, for older data use logs2 or Arne's Clickhouse database.

I am now working on replicating the autosequencing addition on logs2 wsprdaemon_spots and _noise tables. There will be some disruption on 13 August.

thank you
Gwyn

Join wsprdaemon@groups.io to automatically receive all group messages.