Ansible role for PostgreSQL

This is a simple role that will install PostgreSQL and handle users, databases and configuration.

The role should work on all Debian-based distributions.

By default, the role will install PostgreSQL 11 from the PGDG APT repository. You can set a version with postgresql_version.

Sample playbook

---

- hosts: myhost
  roles:
    - name: postgresql
      tags: postgresql
  vars:
    postgresql_version: 11
    postgresql_install_from_pgdg: true
    postgresql_options:
      - {key: listen_addresses, value: "'*'"}
      - {key: max_connections, value: 200}
      - {key: shared_buffers, value: 1GB}
    postgresql_databases:
      - name: blog
    postgresql_users:
      - name: blog
        password: "{{ vault_postgresql_password_blog }}"
        db: blog