ansible-roles/pgbouncer

PgBouncer

Installation and basic configuration of PgBouncer.

Tasks

Everything is in the tasks/main.yml file.

Available variables

Main variables are :

• pgbouncer_listen_addr: the listen IP for PgBouncer (default: 127.0.0.1),
• pgbouncer_listen_port: the listen post for PgBouncer (default: 6432),
• pgbouncer_databases: the databases that clients of PgBouncer can connect to,
• pgbouncer_account_list: the accounts that clients of PgBouncer can connect to.

The variable pgbouncer_databases must have the name, host and port attributes. The variable can be defined like this:

pgbouncer_databases:
  - { name: "db1", host: "192.168.3.14", port: "5432" }
  - { name: "*", host: "192.168.2.71", port: "5432" }

The variable pgbouncer_account_list must have the name and hash attributes. The variable can be defined like this:

pgbouncer_account_list:
  - { name: "account1", hash: "<hash>" }
  - { name: "account2", hash: "<hash>" }

The value of hash can be obtained by running this command on the PostgreSQL server: select passwd from pg_shadow where usename='account1';

These accounts must exist on the PostegreSQL server.

The full list of variables (with default values) can be found in defaults/main.yml.