remote read is not showing metrics

[anil4u-04]

Hi ,

I have configured remote write for the prometheus , and i can see remote writes are happening, I can see the data in the postgres (db : prometheus , table metrics_values).

i have configured another prometheus for remote read which i want to add as a datastore in the grafana, but i can't see the metrics flowing to prometheus.

my setup is like this.

prometheus_server-01 --> had all the targets configured and will write to the remote storage which is postgresql (postgresql_server-01)

prometheus_server-02 --> want to read the data from the postgresql (postgresql_server-01).

and in the grafana i want to create a prometheus dashboard with the prometheus_server-02 (configured for read).

i am not quite sure whether this is the normal approach to follow for remote_read , or i am completely miss understand the whole concept.

can someone please help me with this.

Thanks in well advance.

[sherif84]

hi @anil4u-04 , I'm facing the situation, did you solve this yet?

if not, @pgadapter team, any guidance will be appreciated

[anil4u-04]

@sherif84 .

Sorry for the late reply. No i didn't get any help in this. Even i am also looking forward some help.

[bboule]

hello @anil4u-04 quick question for you, is there any reason you are not just connecting Garfana directly to postgresql database running timescale? if you are worried about performance perhaps a more streamlined approach is to create a replica of the postgres server where your metrics are ending up and use that as a read only server for Grafana (using the PostgreSQL adapter and the Timescale flag)

Let me know if this seems like a reasonable approach to the problem?

[anil4u-04]

@bboule , my use case was , we have multiple clients and i dont want to have multiple datasources in the grafana. so i use remote_write and then i can have single datasource. Anyway this is not required anymore. But still want to know is there anyway that we can achieve this. Thanks