ansible/roles/configure-db/tasks/main.yml


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

---
# 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