ansible/host_vars/bdd-ovh.adm.auro.re.yml

---
postgresql:
  version: 13

postgresql_hosts:
  - database: etherpad
    user: etherpad
    net: 10.128.0.150/32
    method: md5
  - database: codimd
    user: codimd
    net: 10.128.0.150/32
    method: md5
  - database: synapse
    user: synapse
    net: 10.128.0.56/32
    method: md5
  - database: kanboard
    user: kanboard
    net: 10.128.0.150/32
    method: md5
  - database: grafana
    user: grafana
    net: 10.128.0.150/32
    method: md5
  - database: cas
    user: cas
    net: 10.128.0.150/32
    method: md5

postgresql_databases:
  - synapse
  - codimd
  - etherpad
  - kanboard
  - grafana
  - cas

postgresql_users:
  - name: synapse
    database: synapse
    password: "{{ postgresql_synapse_passwd }}"
    privs:
      - ALL
  - name: codimd
    database: codimd
    password: "{{ postgresql_codimd_passwd }}"
    privs:
      - ALL
  - name: etherpad
    database: etherpad
    password: "{{ postgresql_etherpad_passwd }}"
    privs:
      - ALL
  - name: kanboard
    database: kanboard
    password: "{{ postgresql_kanboard_passwd }}"
    privs:
      - ALL
  - name: grafana
    database: grafana
    password: "{{ postgresql_grafana_passwd }}"
    privs:
      - ALL
  - name: cas
    database: cas
    password: "{{ postgresql_cas_passwd }}"
    privs:
      - ALL
...