tasks/config_postgres.yml

   1 - name: PostgreSQL - nextcloud_php_user role is created
   2   become_user: postgres
   3   become: true
   4   community.postgresql.postgresql_user:
   5     name: "php_{{ SIGLE }}_{{ config_ss_domain }}"
   6     state: present
   7     role_attr_flags: CREATEDB
   8
   9 - name: PostgreSQL -  nextcloud_db_name  database is created
  10   become_user: postgres
  11   become: true
  12   community.postgresql.postgresql_db:
  13     name: "php_{{ SIGLE }}_{{ config_ss_domain }}"
  14     state: "{{ item }}"
  15     owner: "php_{{ SIGLE }}_{{ config_ss_domain }}"
  16   loop:
  17     - absent
  18     - present
  19
  20 - name: Autoriser l'utilisateur php à se connecter à la bdd nextcloud
  21   community.postgresql.postgresql_pg_hba:
  22     dest: "/etc/postgresql/{{ postgres_version }}/main/pg_hba.conf"
  23     contype: local
  24     users: "php_{{ SIGLE }}_{{ config_ss_domain }}"
  25     databases: "php_{{ SIGLE }}_{{ config_ss_domain }}"
  26     method: peer
  27     keep_comments_at_rules: true
  28     comment: "autoriser le user php_{{ SIGLE }}_{{ config_ss_domain }} à se connecter à la bdd du meme nom"
  29
  30 - name: Recharger postgresql
  31   ansible.builtin.service:
  32     name: "{{ item }}"
  33     state: reloaded
  34   loop:
  35     - "postgresql"