Ansible Role: PgBouncer

This is an Ansible role for PgBouncer, which is a lightweight connection pooler for PostgreSQL. It currently works on Debian and RedHat-based Linux systems. The tested platforms are:

• Ubuntu 16.04
• CentOS 7

Requirements

No special requirements are needed.

Role Variables

Here are some variables you can use with this role, along with a short description. (For all the variables, see defaults/main.yml)

pgbouncer_listen_addr: 0.0.0.0       # Address to listen on
pgbouncer_listen_port: 6432          # Port to listen on

pgbouncer_auth_type: md5              # Authentication type
pgbouncer_users:                      # User configurations
  - name: worker                      # Username
    pass: 123456                     # Password

Dependencies

No dependencies are needed.

Example Playbook

Here is an example of how to use this role in a playbook:

- hosts: pgbouncer

  roles:
    - role: mbaran0v.pgbouncer

License

MIT / BSD

Author Information

This role was created in 2019 by Maxim Baranov.