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 configure to connect to Postgres with a different user account than postgres #112

Closed zoechi closed 4 years ago

zoechi commented 4 years ago

Postgres is the admin account and I don't think it's a good idea to use this account to connect to the RDMBS. How can the connector be configured a different account and what permissions are required for that account in the database?

zoechi commented 4 years ago

Perhaps related to #45 #78

zoechi commented 4 years ago

I found

docker run -ti timescale/prometheus-postgresql-adapter --entrypoint "prometheus-postgresql-adapter -h"

which reveals TS_PROM_PG_USER

Is it enough to add the new user to the role prom_writer?

zoechi commented 4 years ago

I just saw this project is discontinued in favor of https://github.com/timescale/timescale-prometheus