...then move on to configuring *prometheus* I meant. On Wednesday 8 May 2024 at 07:11:46 UTC+1 Brian Candler wrote:
> - job_name: 'postgresql_exporter' > static_configs: > - targets: ['host.docker.internal:5432'] > > One problem I can see is that you're trying to get prometheus to scrape > the postgres SQL port. If you go to the Prometheus web UI and look at the > Status > Targets menu option, I think you will see it's currently failing. > Or run the query "up == 0". > > You need to change it to scrape prometheus exporter: that is port 9187, > not port 5432. > > However, before you get around to configuring prometheus, I suggest you > first make sure that postgres-exporter itself is working properly, by > scraping it manually: > > curl x.x.x.x:9187/metrics > > (or inside the exporter container you could try curl > 127.0.0.1:9187/metrics, but that depends if the container has a "curl" > binary) > > Once you're able to do that (which may also require adjusting your > postgres_exporter.yml and/or pg_hba.conf, then move on to configuring > postgres. > > On Tuesday 7 May 2024 at 21:24:18 UTC+1 Christian Sanchez wrote: > >> Hello, all. >> >> I've started to learn Prometheus and found out about the >> postgres_exporter. I'd like to include metrics from the PostgreSQL server I >> have running on Google Cloud. >> >> I don't understand how to actually build out the postgres_exporter.yml >> file. The prometheus-community GitHub repository >> <https://github.com/prometheus-community/postgres_exporter> doesn't seem >> to have examples of building this file out. >> >> Maybe I am not reading the README in the repo that well, but I'd like to >> see some examples of the exporter file. >> >> When running the Prometheus container, this is where I'm expecting to see >> the exporter query options (see attachment) >> >> >> I am running Prometheus and the Postgres Exporter through Docker Compose. >> Here is my docker-compose.yml file: >> version: '3' >> services: >> prometheus: >> image: prom/prometheus >> volumes: >> - "./prometheus.yml:/etc/prometheus/prometheus.yml" >> ports: >> - 9090:9090 >> >> postgres-exporter: >> image: prometheuscommunity/postgres-exporter >> volumes: >> - "./postgres_exporter.yml:/postgres_exporter.yml:ro" >> ports: >> - 9187:9187 >> environment: >> DATA_SOURCE_NAME: " >> postgresql://my-user:my-pa...@host.docker.internal:5432/my-database?sslmode=disable >> " >> >> >> Here is my prometheus.yml file: >> global: >> scrape_interval: 45s >> >> scrape_configs: >> - job_name: 'prometheus' >> static_configs: >> - targets: ['localhost:9090'] >> >> - job_name: 'postgresql_exporter' >> static_configs: >> - targets: ['host.docker.internal:5432'] >> >> >> -- 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/8d5d968c-0714-4ffe-885d-911e1a243cc9n%40googlegroups.com.
