TimescaleDB on Postgres
Posted: Mon Dec 10, 2018 3:49 amI am loving Grafana, but one of the biggest issues is that the use of influxDB means I am missing 2 years of history from sqllogger. I know that postgres is not a time series optimised db, but I have seen that Grafana supports TimescaleDB
https://docs.timescale.com/v1.0/getting ... ating-data
It looks like you can migrate existing postgres db to use the timescale db plugin on postgres, but if I did that, would the sqllogger still be able to write to it?
OR, should I duplicate the postgresdb and migrate a static version that I no longer write to. I can then use that static version for old queries, and influx for more recent data?
https://docs.timescale.com/v1.0/getting ... ating-data
It looks like you can migrate existing postgres db to use the timescale db plugin on postgres, but if I did that, would the sqllogger still be able to write to it?
OR, should I duplicate the postgresdb and migrate a static version that I no longer write to. I can then use that static version for old queries, and influx for more recent data?