Page MenuHomeDevCentral
Files F3767677

No OneTemporary
Actions

View Options

diff --git a/pillar/dbserver/cluster-A.sls b/pillar/dbserver/cluster-A.sls
index 957ae8a..370c714 100644
--- a/pillar/dbserver/cluster-A.sls
+++ b/pillar/dbserver/cluster-A.sls
@@ -1,172 +1,177 @@
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
corspat:
password: dbserver/cluster-A/users/corspat
privileges:
- database: corspat
scope: schema
privileges:
- ALL
dovecot:
password: dbserver/cluster-A/users/dovecot
privileges:
- database: mail
scope: table
schema: public
tables:
- mailbox
privileges:
- SELECT
fantoir:
password: dbserver/cluster-A/users/fantoir
privileges:
- database: fantoir
scope: schema
privileges:
- ALL
mailManagement:
password: dbserver/cluster-A/users/mailManagement
privileges:
- database: mail
scope: schema
privileges:
- SELECT
- INSERT
- UPDATE
- DELETE
tables:
- ALL
netbox:
password: dbserver/cluster-A/users/netbox
privileges:
- database: netbox
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
- database: forms
scope: table
schema: public
tables:
- ALL
privileges:
- ALL
postfix:
password: dbserver/cluster-A/users/postfix
privileges:
- database: mail
scope: table
schema: public
tables:
- ALL
privileges:
- SELECT
databases:
airflow:
encoding: UTF8
owner: airflow
corspat:
encoding: UTF8
owner: corspat
fantoir:
encoding: UTF8
owner: fantoir
extensions:
- pg_trgm
forms:
encoding: UTF8
owner: orbeon
mail:
encoding: UTF8
owner: mailManagement
netbox:
encoding: UTF8
owner: netbox
openfire:
encoding: UTF8
owner: openfire
# Network connections allowed in pg_hba.conf
connections:
- db: airflow
user: airflow
ips: 172.27.27.0/28
- db: corspat
user: corspat
ips: 172.27.27.5/32
- db: fantoir
user: fantoir
ips: 172.27.27.0/28
- db: forms
user: orbeon
ips: &dwellers 172.27.27.4/32
method: password
+ - db: mail
+ user: dovecot
+ ips: 172.27.27.3/32
+ method: password
+
- db: mail
user: mailManagement
ips: 172.27.27.3/32
method: password
- db: mail
user: postfix
ips: 172.27.27.3/32
method: password
- db: netbox
user: netbox
ips: 172.27.27.0/28
- db: openfire
user: openfire
ips: &docker002 172.27.27.5/32
method: password

File Metadata

Mime Type
text/x-diff
Expires
Mon, Nov 25, 02:48 (17 h, 46 m)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
2257367
Default Alt Text
(3 KB)

Event Timeline

Nasqueron DevCentral · If it had been much bigger the moon would have had a core of ice. · Powered by Phabricator