Hi Prashant, I have not used the Postgres exporter, but judging by the code at https://github.com/prometheus-community/postgres_exporter/blob/dcf498e709b121eb1ff2e193f66c8ff2d4611b58/cmd/postgres_exporter/postgres_exporter.go#L663-L703, the "pg_exporter_last_scrape_error" metric having a value of 1 means that the exporter was unable to connect to the Postgres backend. It also logs the specific error message, so you should be able to see the exact backend connection error reason in your exporter's logs.
Kind regards, Julius On Wed, Jun 28, 2023 at 12:51 PM Prashant Singh <prashantnit...@gmail.com> wrote: > Dear All, > > I have installed postgres exporter on posgres Master DB server. but I > have getting below error. please sugest , how can solve this. > > error . > > pg_exporter_last_scrape_error 1 > pg_exporter_scrapes_total 256 > pg_scrape_collector_duration_seconds{collector="bgwriter"} 0.003357295 > pg_scrape_collector_duration_seconds{collector="database"} 0.005279667 > pg_scrape_collector_success{collector="bgwriter"} 0 > pg_scrape_collector_success{collector="database"} 0 > pg_up 0 > > Thanks, > Prashant > > -- > 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 prometheus-users+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/prometheus-users/1fdbc0f2-4662-479f-ae8e-d82e0d1037c3n%40googlegroups.com > <https://groups.google.com/d/msgid/prometheus-users/1fdbc0f2-4662-479f-ae8e-d82e0d1037c3n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Julius Volz PromLabs - promlabs.com -- 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 prometheus-users+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/prometheus-users/CAObpH5y%3Dei_Gh5ofu3c%3Dg3kdQRv-23MF1%3DJQBo0wzCDuxpWYTA%40mail.gmail.com.