telegraph-pgbouncer

Poll pgBouncer for stats to submit to Telegraf using the Exec Input Plugin.

Usage

The application is meant to be used via the Exec Input Plugin

Example Telegraf Configuration

[[inputs.exec]]
  ## Commands array
  commands = [
    "telegraf-pgbouncer -h localhost -p 6432 -U monitor all"
  ]
  timeout = "5s"
  name_suffix = "_pgbouncer"
  data_format = "json"

CLI Usage

$ telegraf-pgbouncer --help
usage: pgBouncer Stats Collector for Telegraf

positional arguments:
  COMMAND               The SHOW command to run for extracting stats. Choices:
                        all, lists, databases, mem, pools, stats

optional arguments:
  -h HOST, --host HOST  database server host or socket directory (default: localhost)
  -p PORT, --port PORT  database server port number (default: 5432)
  -U USERNAME, --username USERNAME
                        The PostgreSQL username to operate as (default: pgbouncer)
  -W, --password        Force password prompt (should happen automatically)
                        (default: False)
  -v, --version         output version information, then exit
  -?, --help            show this help, then exit

Authentication

Specify the password in a .pgpass file for the application to connect properly without specifying a password.