Crunchy Data is pleased to announce the initial release of the PostgreSQL Prometheus Adapter, a remote storage adapter for enabling Prometheus to use PostgreSQL as a storage system for time-series metrics. You can find the PostgreSQL Prometheus Adapter project here:
https://github.com/CrunchyData/postgresql-prometheus-adapter
PostgreSQL Prometheus Adapter leverages PostgreSQL 12's native partitioning enhancements to efficiently store Prometheus time series data in a PostgreSQL database. 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-1
The PostgreSQL Prometheus Adapter is released under an Apache 2.0 license. We welcome your feedback and contributions to the project!
Crunchy Data is proud to support the development and maintenance of the PostgreSQL Prometheus Adapter.