consul-template pgbouncer config

pgbouncer.conf

# /etc/consul-template/conf.d/pgbouncer.conf
template {
  source          = "/etc/consul-template/templates/pgbouncer.ini.tmpl"
  destination     = "/etc/pgbouncer/pgbouncer.ini"
  command         = "service pgbouncer reload"
  command_timeout = "60s"
  backup          = true
}

pgbouncer.ini.tmpl

; /etc/consul-template/templates/pgbouncer.ini.tmpl

[databases]

; the honeybadger portion of postgres/honeybadger/leader is the patroni cluster name
honeybadger = host={{ key "postgres/honeybadger/leader" }} port=5432 dbname=honeybadger

; ...