- name: PostgreSQL - nextcloud_php_user role is created
  become_user: postgres
  become: true
  community.postgresql.postgresql_user:
    name: "php_{{ SIGLE }}_{{ config_ss_domain }}"
    state: present
    role_attr_flags: CREATEDB

- name: PostgreSQL -  nextcloud_db_name  database is created
  become_user: postgres
  become: true
  community.postgresql.postgresql_db:
    name: "php_{{ SIGLE }}_{{ config_ss_domain }}"
    state: "{{ item }}"
    owner: "php_{{ SIGLE }}_{{ config_ss_domain }}"
  loop:
    - absent
    - present

- name: Autoriser l'utilisateur php à se connecter à la bdd nextcloud
  community.postgresql.postgresql_pg_hba:
    dest: "/etc/postgresql/{{ postgres_version }}/main/pg_hba.conf"
    contype: local
    users: "php_{{ SIGLE }}_{{ config_ss_domain }}"
    databases: "php_{{ SIGLE }}_{{ config_ss_domain }}"
    method: peer
    keep_comments_at_rules: true
    comment: "autoriser le user php_{{ SIGLE }}_{{ config_ss_domain }} à se connecter à la bdd du meme nom"

- name: Recharger postgresql
  ansible.builtin.service:
    name: "{{ item }}"
    state: reloaded
  loop:
    - "postgresql"