ive got a running icinga master with connect to my ELK.
i ship the new metrics all to the ELK with the icingabeat and read them with the elastic module.
so far so good…
but is there a way to migrate and properly index the old metrics which where actually only insight the local icinga postgresql DB to the ELK ?
Icinga doesn’t store any metrics in the IDO database backend. It stores state changes, notifications, etc in historical tables if that’s of interest. Exporting such would require SQL magic and forwarding them to Elasticsearch then.
Question aside - why would you want to store metrics in Elastic Stack? Imho Graphite/InfluxDB/Prometheus solve a better TSDB purpose here.
I doubt that metrics are a good idea in Elasticsearch in the long term, regarding aggregation, storage and performance, but truly it is your system and you’re taking the decisions and results.
In terms of migration possibilities I don’t see any, unless you kept storing existing performance data metrics in TSDB systems like Graphite, InfluxDB, etc.