Hi,
I wanted to announce the initial release of the PostgreSQL Prometheus Adapter project available here:
https://github.com/CrunchyData/postgresql-prometheus-adapterThis remote storage adapter allows you to use PostgreSQL to store metrics from Prometheus. It leverages PostgreSQL 12's native partitioning enhancements to efficiently store Prometheus data in a PostgreSQL database without requiring any additional installations or extensions. Incoming data is processed by one or more threads that store the data in PostgreSQL partitions that are automatically created hourly or daily.
You can run the PostgreSQL Prometheus Adapter either as a cross-platform native application or within a container. We've provided a guide for how you can set up and use the PostgreSQL Prometheus Adapter here:
https://info.crunchydata.com/blog/using-postgres-to-back-prometheus-for-your-postgresql-monitoring-1The PostgreSQL Prometheus Adapter is released under an Apache 2.0 license. We welcome any feedback and contributions to the project!
Thanks,
Jonathan