feat(roles/nextcloud): automate with occ

1 files changed, 18 insertions, 0 deletions

diff --git a/roles/nextcloud/tasks/database.yml b/roles/nextcloud/tasks/database.yml
new file mode 100644
index 0000000..601ee9d
--- /dev/null
+++ b/roles/nextcloud/tasks/database.yml
@@ -0,0 +1,18 @@
+---
+
+- name: create nextcloud database
+  community.postgresql.postgresql_db:
+    name: "{{ nextcloud__db_name }}"
+    encoding: UTF-8
+
+- name: create nextcloud database user
+  community.postgresql.postgresql_user:
+    db: "{{ nextcloud__db_name }}"
+    name: "{{ nextcloud__db_user }}"
+    password: "{{ nextcloud__db_password }}"
+
+- name: add nextcloud db user permissions
+  community.postgresql.postgresql_schema:
+    db: "{{ nextcloud__db_name }}"
+    name: "{{ nextcloud__db_user }}"
+    owner: "{{ nextcloud__db_user }}"