Connecting to database from prometheus_exporter

user_14371594 0
Viewed 1152

To collect Postgres metrics in prometheus, postgres_exporter is used. Containerization is not used, everything is done natively. Hardware metrics are collected in a prometheus through a job. To collect database metrics, I need to connect the prometheus_exporter to the database. Tell me how to configure the connection to the database. postgres_exporter has no configuration files. Шs it possible to do this via environment variables?

prometheus.yml:

scrape_configs:
     - job_name: postgresql
        static_configs:
          - targets: ['xx.xx.xx.xx:9187']
            labels:
              alias: postgres
grafana prometheus environment-variables postgresql
2 Answers

Is it possible to do this via environment variables?

Yes, it is possible. Here is the list of supported variables: https://github.com/prometheus-community/postgres_exporter#environment-variables

How to configure the connection to the database

A simple example to launch from console:

DATA_SOURCE_NAME="user=postgres host=database.example.com" postgres_exporter

or

DATA_SOURCE_NAME="postgresql://user:password@host:port/dbname" postgres_exporter

If you installed the exporter from distribution packages, there's probably a systemd unit file to run it as a service:

# systemctl cat prometheus-postgres-exporter
# /lib/systemd/system/prometheus-postgres-exporter.service

[Unit]
Description=Prometheus PostgreSQL Exporter
Wants=network-online.target

[Service]
User=postgres
ExecStart=/usr/sbin/postgres-exporter $OPTIONS

# You can place environment variables in this file ⤋
EnvironmentFile=/etc/default/prometheus-postgres-exporter

[Install]
WantedBy=multi-user.target
user_113445020

DATA_SOURCE_NAME="postgresql://user:password@host:port/dbname?sslmode=disable" Here at the end dbname is must to avoid error. For my case I found it is ok now.

DATA_SOURCE_NAME="postgresql://grafana:p@host:192.168.1.100/postgres?sslmode=disable"
user_41186700
Related