Add new metricity PostgreSQL user

2 files changed, 40 insertions, 24 deletions

diff --git a/ansible/roles/postgres/vars/main/db_passwords.yml b/ansible/roles/postgres/vars/main/db_passwords.yml
index 398cafc..fb9e975 100644
--- a/ansible/roles/postgres/vars/main/db_passwords.yml
+++ b/ansible/roles/postgres/vars/main/db_passwords.yml
@@ -1,25 +1,29 @@
 $ANSIBLE_VAULT;1.1;AES256
-36363439326237393135336433383361666265633938663237643635373030636138346166353937
-6364383432326363303438356532323066646231343361660a656561643463346333643334383031
-38653136336431663636336532636231633931373431663237323063326436646133353865363134
-3638643562636536330a643336356333656433333736643336306338613837383034336438373736
-34396235323839383236393934633137326166393766306231643233323639316563336562323733
-34356564663133303639326236366562333737656161356532323665636534323139623330306133
-66656436373139333933623232313464386262613237393236623734356139376262313335393431
-34376562373266316134616234383164363432343930316365646130393463366164653137646330
-31616639626535646564366530323665386163323764313063386439346565366639303733376361
-65373064646435633738663735306561366330353261646139353930386266366465613731363633
-36643862316565646332646236353237646530386433346164303834396365656635646137333733
-32666239346231663838303766626165343135373661363337363533316262663433623262333732
-65613966303937323930626662376333613463356530646463363333346265363433373436346631
-63636536663836366138636530656563626236366535653033663233663934343132623964666636
-66373937373737623462323333663139353232633135636339316233313738323537656562333235
-35373333646632343734653539363264303534353034633765653336633234396431333632643162
-36333166643165623761353263383132666236666139393461386438326563646435386335373433
-32393439663833356133323766383238396638333766326561376433613131333638666136353565
-63363831613665306430343064386362633765383733656663323064376536353534386265396462
-63646331343531333863326435303736396261383661313437616634663430383362643737613737
-36656536666366343132336363366661313233336136636131373738656332323663333035636339
-63623432643537393862333161663663373865343838353134313837646235336231326265623363
-30343630633932633034653733316364363730633237636164616431376437383537346135643166
-33396436636164626634
+33323139363965656336373638346238616137373563396164363966663133346139666262323766
+6366623134383761353833373830313266613439643631390a666135346462303638396134376233
+37353435363838393738626334653762333630653039396661613262373964376432616661623739
+3064303439653961380a306535326665316666343637336266356539373863333062383864336239
+34613435316438316465383661633461393835643535316364373963343561363930333232303537
+65323036646638313737333837353738356462323731396430353361656232323830393734613863
+36326261623563323435643034303634316330336464663334393337343135326638383164643062
+33663032623139346461303762343730393332393236663031316236336237373864326238313931
+39396237396237333037663233353838623365386362376431326432393862663033323038396536
+39336134616131343265626566616565303634383662373836636631356364646533396637383764
+33373466636230643834616463383133636533303034306165323330393163353339303263323236
+61313835393761336136346136643764643831383437633733326230376566313235663663373764
+30353534343834323263623362343565353063643764346239653435356561633735666363376436
+30383965393761356561656131613534353930643662393137303263376561653631346465356431
+31343261626164653061633230353965613761343664623564316131336434356336663762396164
+36316138383963613533613535656265393232656638373162333535313430353931306236626365
+63356566356661353237653462336230326339356230353036653766633834623061366436663162
+39323264303634643636333736363630353632306431373439333831383430383634323334626632
+63343832363164653138333561333663366562643666626663626636306363373432353861623066
+37326364343261393562326436653434343865303266383365346466646631376332653965396135
+65663634636637303661366332313464656230666435336330633535656432633936386132613639
+30653962393766343133346534653661656663633432616638623062663664306534636664636262
+34336661326661653532356531313665656530306262376430633464333636333336333631396266
+36636632363738396435616132663035353637353861636163386135366361653631633431633966
+37326166316639316130353133636534353731333034303337386662613065653266393166323262
+33383161613433656132303362353034616464623437343230383337313631663434343936323936
+65393361323262386133326164363733323562343430646136343430383864366661633533303530
+31393135373865626262
diff --git a/ansible/roles/postgres/vars/main/main.yml b/ansible/roles/postgres/vars/main/main.yml
index f9b3b35..1e94b20 100644
--- a/ansible/roles/postgres/vars/main/main.yml
+++ b/ansible/roles/postgres/vars/main/main.yml
@@ -24,6 +24,11 @@ postgres_users:
     password: "{{ vault_postgres_user_passwords.codejam_management }}"
     roles:
 
+  - name: metricity
+    password: "{{ vault_postgres_user_passwords.metricity }}"
+    roles:
+
+
 postgres_hba_rules:
   - conn_type: hostssl
     database: pinnwand
@@ -55,6 +60,11 @@ postgres_hba_rules:
     address: all
     method: scram-sha-256
 
+  - conn_type: hostssl
+    database: metricity
+    user: metricity
+    address: all
+    method: scram-sha-256
 
 postgres_databases:
   - name: pinnwand
@@ -65,3 +75,5 @@ postgres_databases:
     owner: blackknight
   - name: codejam_management
     owner: codejam_management
+  - name: metricity
+    owner: metricity