---
- name: Install Postgres
  block:
    - name: Install debian packages
      apt:
        name: "{{ postgres_packages }}"
        state: present
      register: psql
    
    - name: Create DB user
      become: yes
      become_user: postgres
      community.postgresql.postgresql_user:
        name: "{{ nc_db_user }}"
        password: "{{ nc_db_pass }}"
    
    - name: Create nextcloud db
      become: yes
      become_user: postgres
      community.postgresql.postgresql_db:
        name: nextcloud
        template: template0
        encoding: UNICODE
        owner: "{{ nc_db_user }}"
    
    - name: Grant privilages for db to user
      become: yes
      become_user: postgres
      community.postgresql.postgresql_user:
        name: "{{ nc_db_user }}"
        db: "{{ nc_db_name }}"
        priv: ALL
  when: "{{ nc_db == 'pgsql' }}"