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