diff --git a/pillar/dbserver/cluster-A.sls b/pillar/dbserver/cluster-A.sls index a31bb37..53999e5 100644 --- a/pillar/dbserver/cluster-A.sls +++ b/pillar/dbserver/cluster-A.sls @@ -1,66 +1,83 @@ dbserver_postgresql: server: cluster: A # Fantoir database needs the pg_trgm extension with_contrib: True listen_addresses: "*" users: # Password paths are relative to ops/secrets/ airflow: password: dbserver/cluster-A/users/airflow privileges: - database: airflow scope: schema privileges: - ALL fantoir: password: dbserver/cluster-A/users/fantoir privileges: - database: fantoir scope: schema privileges: - ALL + openfire: + password: dbserver/cluster-A/users/openfire + privileges: + - database: openfire + scope: schema + privileges: + - ALL + orbeon: password: dbserver/cluster-A/users/orbeon privileges: - database: forms scope: schema privileges: - ALL databases: airflow: encoding: UTF8 owner: airflow fantoir: encoding: UTF8 owner: fantoir extensions: - pg_trgm forms: encoding: UTF8 owner: orbeon + openfire: + encoding: UTF8 + owner: openfire + # Network connections allowed in pg_hba.conf connections: - db: airflow user: airflow ips: 172.27.27.0/28 - db: fantoir user: fantoir ips: 172.27.27.0/28 - db: forms user: orbeon ips: &dwellers 172.27.27.4/32 method: password + + - db: openfire + user: openfire + ips: &docker002 172.27.27.5/32 + method: password