afegit expose a les bbdd ekiwi, partago, alterna

inventory/host_vars/carsharing.coop/expose_postgresql.yml

@@ -32,6 +32,21 @@ expose_postgresql_users:
     db: sm
     objs: "ALL_IN_SCHEMA"
     privs: "SELECT"
+  - name: "{{ bi_db_user }}"
+    password: "{{ bi_db_password }}"
+    db: alterna
+    objs: "ALL_IN_SCHEMA"
+    privs: "SELECT"
+  - name: "{{ bi_db_user }}"
+    password: "{{ bi_db_password }}"
+    db: ekiwi
+    objs: "ALL_IN_SCHEMA"
+    privs: "SELECT"
+  - name: "{{ bi_db_user }}"
+    password: "{{ bi_db_password }}"
+    db: partago
+    objs: "ALL_IN_SCHEMA"
+    privs: "SELECT"
 
 expose_postgresql_hba_entries:
   - contype: hostssl
@@ -39,6 +54,21 @@ expose_postgresql_hba_entries:
     source: "{{ bi_ip }}/32"
     databases: sm
     method: md5
+  - contype: hostssl
+    users: "{{ bi_db_user }}"
+    source: "{{ bi_ip }}/32"
+    databases: alterna
+    method: md5
+  - contype: hostssl
+    users: "{{ bi_db_user }}"
+    source: "{{ bi_ip }}/32"
+    databases: ekiwi
+    method: md5
+  - contype: hostssl
+    users: "{{ bi_db_user }}"
+    source: "{{ bi_ip }}/32"
+    databases: partago
+    method: md5
 
 postgresql_conf:
   - option: listen_addresses