I would recommend using the SQL exporter. The postgres_exporter is meant to provide metrics about the PostgreSQL server, not the data in databases.
https://github.com/free/sql_exporter On Tue, Mar 30, 2021 at 2:19 PM Adrien <[email protected]> wrote: > Hi, > > I need to export the result of a postgres select query, I tried to use a > postgres exporter ( > https://github.com/prometheus-community/postgres_exporter) but there is a > glitch: it seems there is no way to run custom queries on specific > database: they are ran on every db, leading to errors in logs, there is an > enhancement request about that. ( > https://github.com/prometheus-community/postgres_exporter/issues/443) > Does someone have an idea how to workaround this ? > > Thanks > > -- > You received this message because you are subscribed to the Google Groups > "Prometheus Users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/prometheus-users/3c6e79f3-1a05-44b0-9fff-f905d2cdf483n%40googlegroups.com > <https://groups.google.com/d/msgid/prometheus-users/3c6e79f3-1a05-44b0-9fff-f905d2cdf483n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Prometheus Users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/CABbyFmqPUu_3bQf%3D0UTGZZh_K1ztNnBAjWTnKjkd-m57wKkQ_Q%40mail.gmail.com.
