Page MenuHomeDevCentral
Files F12944494

cluster-A.sls
No OneTemporary
Actions

cluster-A.sls
View Options

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/plain
Expires
Tue, Nov 18, 17:18 (1 d, 9 h)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
3157437
Default Alt Text
cluster-A.sls (3 KB)

Event Timeline

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