This role installs and configures the PgBouncer connection pooler for PostgreSQL.
It has only been designed to work on Ubuntu 16.04, but other Debian flavours should also work.
None.
The pgbouncer_databases array allows a very dynamic database setup. Any
property allowed in the connection string can be defined under this array and
will automatically be added to the alias definition. The example below
configures a dev database alias that pools connections to the postgres
database on postgres:5432 connecting as foo:md5asdofiasodfa09f9832f. You can
define more databases in the same fashion.
pgbouncer_databases:
- dev:
host: postgres # or the actual ip address
port: 5432
dbname: postgres
user: foo
password: md5asdofiasodfa09f9832fThis role can also optionally install the postgresql-client package for
command-line access to PostgreSQL or PgBouncer. To install this package set
pgbouncer_install_psql: true.
The configuration template allows some values to be overridden. To achieve this,
create a variable named after the configuration property you want to change and
prefix it with pgbouncer_. For example, to override the default listen_port
of 6432, pass a variable named pgbouncer_listen_port. See the template file
for other configs that can be overridden this way. Note that not all settings
are available, only some common ones that I use.
Note: Some variables expect an array - it should be obvious which ones.
See the defaults/main.yml for more descriptions of other
variables. You should also check
templates/pgbouncer.ini.j2 for possible extra
variables you can set.
pgbouncer_install_state: This is useful for updating PgBouncer to newer
versions after it has already been installed. Use latest to achieve this
functionality.
Documentation related to PgBouncer can be found at the links below:
None.
- hosts: servers
become: yes
roles:
- role: jradtilbrook.pgbouncer
pgbouncer_databases:
- testing:
host: postgres
port: 5432
dbname: postgresMIT