search

timescale / prometheus-postgresql-adapter

Use PostgreSQL as a remote storage database for Prometheus
Apache License 2.0
336 stars 66 forks source link

How to use prometheus-postgres-adapter to connect prometheus to RDS PostgresSQL? #10

Open Sriharivignesh opened 6 years ago

Sriharivignesh commented 6 years ago

I am using prometheus-operator in Kubernetes, and am currently using EBS as a backing store. However I would like to move all prometheus data to Amazon RDS PostgresSQL. Any ideas how to do it? The examples given in the repo landing page seems to assume we are running the database ourselves.

erimatnor commented 6 years ago

@Sriharivignesh Amazon RDS is currently unsupported as we rely on extensions being present in PostgreSQL that aren't yet available on RDS. This might change in the future.

knope commented 6 years ago

bummer

icco commented 6 years ago

@erimatnor besides filing an issue asking for support in RDS of pg_prometheus, are there any other things we can do to help make this happen?

Zemmiph0bia commented 5 years ago

@erimatnor has there been any movement on this? / Is there any way people could provide assistance?

seancurran157 commented 5 years ago

@Sriharivignesh Amazon RDS is currently unsupported as we rely on extensions being present in PostgreSQL that aren't yet available on RDS. This might change in the future.

what extensions are missing?

RickS-C137 commented 5 years ago

As far as I've read in the documentation of CoreOS/prometheus-operator, they are recommending the TimescaleDB extension. That one is requested for two years now and I don't think that it'll come. AWS has announced their own timeseries database, why should they support another one then?