telegraf-pgbouncer 0.3.0

pgBouncer Stats Collector for Telegraf

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.