diff options
| author | Stonewall Jackson <stonewall@sacredheartsc.com> | 2023-02-04 01:23:43 -0500 |
|---|---|---|
| committer | Stonewall Jackson <stonewall@sacredheartsc.com> | 2023-02-04 01:52:13 -0500 |
| commit | 0261e875679f1bf63c8d689da7fc7e014597885d (patch) | |
| tree | 3f19cd74a0c1070944f75437f30b098d6ef2ffcb /roles/prosody/tasks/database.yml | |
| download | selfhosted-0261e875679f1bf63c8d689da7fc7e014597885d.tar.gz selfhosted-0261e875679f1bf63c8d689da7fc7e014597885d.zip | |
initial commit
Diffstat (limited to 'roles/prosody/tasks/database.yml')
| -rw-r--r-- | roles/prosody/tasks/database.yml | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/roles/prosody/tasks/database.yml b/roles/prosody/tasks/database.yml new file mode 100644 index 0000000..675ab11 --- /dev/null +++ b/roles/prosody/tasks/database.yml @@ -0,0 +1,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 |