roles/prosody/tasks/database.yml


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

- name: create database
  postgresql_db:
    name: '{{ prosody_db_name }}'
    state: present
  delegate_to: '{{ postgresql_inventory_host }}'
  become: yes
  become_user: postgres

- name: create database user
  postgresql_user:
    name: '{{ prosody_user }}'
    db: '{{ prosody_db_name }}'
    priv: ALL
    state: present
  delegate_to: '{{ postgresql_inventory_host }}'
  become: yes
  become_user: postgres