Ansible Role: Prometheus PgBouncer Exporter

This Ansible role sets up the Prometheus PgBouncer exporter. It works on Debian and RedHat based Linux systems (only supports systemd). The tested platforms are:

• Ubuntu 16.04
• CentOS 7

Requirements

You need Python3 and pip. It’s recommended to use the role geerlingguy.pip for pip installation.

Role Variables

Here are some key variables you can set for this role (for all variables, check defaults/main.yml):

pgbouncer_exporter_version: 2.0.1
pgbouncer_exporter_host: 127.0.0.1
pgbouncer_exporter_port: 9127
pgbouncer_exporter_log_level: INFO

# Environment variables for the exporter
pgbouncer_exporter_env_variables:
  - PGBOUNCER_PASS=passw0rd!

# PgBouncer connection details
pgbouncer_exporter_pgbouncers:
  - dsn: postgresql://pgbouncer:$(PGBOUNCER_PASS)@127.0.0.1:5432/pgbouncer
    connect_timeout: 5
    include_databases: []
    exclude_databases:
      - pgbouncer

Dependencies

None

Example Playbook

Here's a sample playbook showing how to use this role:

- hosts: prometheus-pgbouncer-exporter
  roles:
    - role: geerlingguy.repo-epel
      when: ansible_os_family == 'RedHat'
    - role: geerlingguy.pip
      pip_package: python36-pip
      when: ansible_os_family == 'RedHat'
    - role: geerlingguy.pip
      pip_package: python3-pip
      when: ansible_os_family == 'Debian'
    - role: mbaran0v.prometheus-pgbouncer-exporter

License

MIT / BSD

Author Information

This role was created in 2019 by Maxim Baranov.