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

Gwyn Griffiths

I will be carrying out maintenance and a change to the wsprdaemon_spots table on logs1.wsprdaemon.org today.
The table may stop updating while the work is underway and you are advised to use logs2.wsprdaemon.org.

I will post a note after the work is complete, and as for the noise table, there will be a new table wsprdaemon_spots_s with an autosequence number.

thank you
Gwyn G3ZIL

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.

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