prometheus-postgresql-adapter

prometheus-postgresql-adapter copied to clipboard

failed to connect postgresql

2

Hi All, I use the pre-built binaries to push the prometheus data to postgresql issue: err="pq: Ident authentication failed for user \"postgres\"" but the postgresql is normal， and the user...

jacobawy

pq: copyin statement has already been closed

4

mondb=# \dt List of relations Schema | Name | Type | Owner --------+----------------+-------+---------- public | metrics_copy | table | postgres public | metrics_labels | table | postgres public | metrics_values...

longtian001

Unclear how to use adapter for read load balance

1

We employ replicated postgres solution and would like to balance read load across replicas. Nonetheless it would be nice if it would work when the replica is promoted to leader....

DeathBorn

Duplicate key value constraint problems

3

Hi, One one of our clusters we're fighting with integrity constraint errors: "level=warn ts=2018-11-13T16:00:00.390643264Z caller=main.go:274 msg="Error sending samples to remote storage" err="pq: duplicate key value violates unique constraint \"metrics_labels_metric_name_labels_key\"" storage=PostgreSQL...

thecodeassassin

Problem with remote read

1

Hi, I've configured promemtheus 2.7.1 remote_write: - url: "http://192.168.2.239:9201/write" remote_read: - url: "http://192.168.2.239:9201/read" I set retention period - 1d in Prometheus I see that data writing to PG (TimeScale DB),...

yvbondarenko

Too many connection error on Postgres

1

After connecting with the adapter, prometheus pods are not stable, restaring too many times. Not able to connecto to postgres database using a client, I keep on getting "Too many...

Haybu

Error Sending Samples to Remote Storage

1

Hi, I am facing issues while running pg-adapter. We are using prometheus (2.8.1) along with Postgresql (10.5) as a remote storage. It was running fine, but when I redeployed the...

Keshav0690

prometheus_postgresql_adapter doesn't stop writing in HA

6

I am running 2 identical prometheus containers talking to their respective prometheus.yml files. adapter1 is running a timescale/prometheus-postgresql-adapter:latest \ on a port (:xxxx) with lockid=1 and locktimeout=25s adapter2 is running...

virasatkhan

postgres-adapter authentication failed for 'postgres' db

2

I am setting this up in kubernetes and getting the below error in adapter logs > _level=info ts=2019-05-10T09:28:20.158622915Z caller=log.go:25 config="&{remoteTimeout:30000000000 listenAddr::9201 telemetryPath:/metrics pgPrometheusConfig:{host:pg-prometheus port:5432 user:postgres password: database:postgres schema: sslMode:disable table:metrics...

admiral-manjinder

How can read metrics data from timescaledb(pg_prometheus) and pass it to prometheus via prometheus-postgresql-adapter

4

``` +--------------------+ +----------------------+ +------------------+ | | | prometheus | | pg_prometheus| | prometheus |

keshav1git