enrise.postgresql

This is an Ansible task for installing and configuring PostgreSQL, as well as creating databases, users, and user privileges.

Requirements

Tested on Ansible 1.5
Tested on Ubuntu 14.04 (trusty), but it should work on any modern Debian based system.

Dependencies

Needs the role enrise.locale

Example playbook

To use this role, build a vars file (vars/php.yml, for example) which you include in your playbook, which contains something like the following:

postgresql_users:
  - username: bar
    password: bar

postgresql_databases:
  - database: bar

postgresql_privileges:
  - username: bar
    database: bar
    privilege: ALL

postgresql_additional_packages:
  - postgresql-contrib

Next, you can include the role in your playbook:

- hosts: all
  sudo: yes
  vars_files:
    - vars/postgresql.yml
  roles:
    - enrise.postgresql

There are a lot of config settings you can overwrite, but you'll have to refer to the file defaults/main.yml to see a list of variables and their description.

Licence

MIT

Feedback? Found a bug? Requests?