ansible-role-nextcloud/tasks/postgresql.yaml

---

- name: debian packages required for database management
  apt:
    pkg: python3-psycopg2
  delegate_to: "{{ (nextcloud_database_host != 'localhost') | ternary(nextcloud_database_host,inventory_hostname) }}"

- name: postgresql user
  postgresql_user:
    name: "{{ nextcloud_database_user }}"
    password: "{{ nextcloud_database_pass }}"
  delegate_to: "{{ (nextcloud_database_host != 'localhost') | ternary(nextcloud_database_host,inventory_hostname) }}"
  become: yes
  become_user: postgres

- name: postgresql database
  postgresql_db:
    name: "{{nextcloud_database_name}}"
    encoding: UTF-8
    lc_collate: "{{nextcloud_postgresql_lc}}"
    lc_ctype: "{{nextcloud_postgresql_lc}}"
    template: template0
    owner: "{{nextcloud_database_user}}"
  delegate_to: "{{ (nextcloud_database_host != 'localhost') | ternary(nextcloud_database_host,inventory_hostname) }}"
  become: yes
  become_user: postgres

- name: postgresql access
  postgresql_privs:
    db: "{{nextcloud_database_name}}"
    privs: ALL
    type: database
    role: "{{ nextcloud_database_user }}"
  delegate_to: "{{ (nextcloud_database_host != 'localhost') | ternary(nextcloud_database_host,inventory_hostname) }}"
  become: yes
  become_user: postgres