---
# Need to always define 'sudo_user: postgres' or it will not work!

- name: Create PostgreSQL bugzilla database
  postgresql_db:  name={{ db_name }}
                  template=template0
                  encoding=UTF8
  sudo_user: postgres
  tags:
    - db

- name: Create PostgreSQL bugzilla user
  postgresql_user:  name={{ db_user }}
                    role_attr_flags=NOSUPERUSER,NOCREATEDB
                    password={{ db_pass }}
                    db={{ db_name }}
                    priv=ALL
  sudo_user: postgres
  tags:
    - db