1 - name: PostgreSQL - nextcloud_php_user role is created
4 community.postgresql.postgresql_user:
5 name: "php_{{ SIGLE }}_{{ config_ss_domain }}"
7 role_attr_flags: CREATEDB
9 - name: PostgreSQL - nextcloud_db_name database is created
12 community.postgresql.postgresql_db:
13 name: "php_{{ SIGLE }}_{{ config_ss_domain }}"
15 owner: "php_{{ SIGLE }}_{{ config_ss_domain }}"
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"
24 users: "php_{{ SIGLE }}_{{ config_ss_domain }}"
25 databases: "php_{{ SIGLE }}_{{ config_ss_domain }}"
27 keep_comments_at_rules: true
28 comment: "autoriser le user php_{{ SIGLE }}_{{ config_ss_domain }} à se connecter à la bdd du meme nom"
30 - name: Recharger postgresql
31 ansible.builtin.service: