diff options
| author |  Joe Banks <[email protected]> | 2024-05-28 21:27:46 +0100 |
|---|---|---|
| committer | Joe Banks <[email protected]> | 2024-05-28 21:27:46 +0100 |
| commit | 0bdd9e6a0a8bf654cbefec0aab644cf3d7191bed (patch) | |
| tree | caf38d804262d5e15646d55bb48e73ffbdb01d54 /ansible/roles/postgres | |
| parent | Update kube-system namespace docs with new metrics-server details (diff) | |
Add new metricity PostgreSQL user
Diffstat (limited to 'ansible/roles/postgres')
| -rw-r--r-- | ansible/roles/postgres/vars/main/db_passwords.yml | 52 | ||||
| -rw-r--r-- | ansible/roles/postgres/vars/main/main.yml | 12 |
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 |