path: root/roles/nextcloud/tasks/database.yml

---

- 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 }}"