I’ve recently been able to recover from a pretty severe PostgreSQL/TimescaleDB data corruption issue (transaction wraparound thing I’m not exactly sure what caused it), but I’m left with an energy dashboard which is quite wonky. I’m missing almost a month of readings from my home smart meter. I don’t have any solar or battery solutions, so I shouldn’t have negative values in my graphs at all. How can I backfill my smart meter values (from my energy provider) to get this back in shape?
I’m quite adept with using PostgreSQL, and I’m planning to get a CSV report of the hourly usage from my energy provider, but once I have that one, how can I backfill without having to manually fix every entry?