prometheus-postgresql-adapter icon indicating copy to clipboard operation
prometheus-postgresql-adapter copied to clipboard

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

Open Sriharivignesh opened this issue 7 years ago • 6 comments

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.

Sriharivignesh avatar Mar 14 '18 03:03 Sriharivignesh

@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.

erimatnor avatar Mar 19 '18 08:03 erimatnor

bummer

knope avatar Apr 09 '18 16:04 knope

@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?

icco avatar May 21 '18 22:05 icco

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

Zemmiph0bia avatar Mar 19 '19 00:03 Zemmiph0bia

@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?

seancurran157 avatar May 01 '19 19:05 seancurran157

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?

RickS-C137 avatar May 07 '19 13:05 RickS-C137