diff options
| author |  shtlrs <[email protected]> | 2024-05-18 16:24:47 +0200 |
|---|---|---|
| committer |  jchristgit <[email protected]> | 2024-05-18 16:34:45 +0200 |
| commit | 42c539fa751ce02424e0bf5c8b73b57c54d3830e (patch) | |
| tree | cd29ec6143a776aa69a7f8d74c1f0ae46a4902bb | |
| parent | Instruct black knight to connect to lovelace (diff) | |
craete codejam pg user
| -rw-r--r-- | ansible/roles/postgres/vars/main/db_passwords.yml | 45 | ||||
| -rw-r--r-- | ansible/roles/postgres/vars/main/main.yml | 12 |
2 files changed, 36 insertions, 21 deletions
diff --git a/ansible/roles/postgres/vars/main/db_passwords.yml b/ansible/roles/postgres/vars/main/db_passwords.yml index dabf99f..398cafc 100644 --- a/ansible/roles/postgres/vars/main/db_passwords.yml +++ b/ansible/roles/postgres/vars/main/db_passwords.yml @@ -1,22 +1,25 @@ $ANSIBLE_VAULT;1.1;AES256 -66653539613236333766363666373837383437643862653866353762373162633264383462396166 -6464356465313166383633616230656161613862666639620a383833303833633137303730336336 -34623133623238633063333837633862343261633536373933373639656632613439656263383961 -6331666565643239610a653732353564636132363962663933616336666562326563333863303436 -38323231636562356434323434663164373232366432356537353436336237353665333035363232 -62303133346333396135613939373536646661626561383337313436646635633662626434633861 -34396365653162626536323336326461616533663962616333643364623065656334633432656337 -32376638636238366536383961653066303831313238633261383935643734626232386232313631 -35323265336335336139376433643034613439663434653031666636376237633937393931323064 -63353135613833366532333766303132326431343633383165363461646535613231363163333862 -65386530376265613066613365396466653539353533303138313963366264386333316461623535 -63656638396565633462393239343737633836333136613931633736343539656235643337663930 -66396236666265313339613936653762386236336461346535303232643833386135396366646265 -37363735313833613565626332633537363035383862353734326630393363613434643838376130 -61616265353364313162653238653534393732383661613633663339383864336435623933653462 -32363137333938633966393538386332616631363231373139613037356464346262363462396638 -32663864316331326436366166323966656563396137666431323762633434613066653830623838 -39393164323964633939343462616463346662376530383137663636303565333634343061316635 -38623831373239303466383430363631653538326466346132633162343832613965356239363339 -30353463623166383864633061333338613438373130386464623764303462346534306264663437 -6438 +36363439326237393135336433383361666265633938663237643635373030636138346166353937 +6364383432326363303438356532323066646231343361660a656561643463346333643334383031 +38653136336431663636336532636231633931373431663237323063326436646133353865363134 +3638643562636536330a643336356333656433333736643336306338613837383034336438373736 +34396235323839383236393934633137326166393766306231643233323639316563336562323733 +34356564663133303639326236366562333737656161356532323665636534323139623330306133 +66656436373139333933623232313464386262613237393236623734356139376262313335393431 +34376562373266316134616234383164363432343930316365646130393463366164653137646330 +31616639626535646564366530323665386163323764313063386439346565366639303733376361 +65373064646435633738663735306561366330353261646139353930386266366465613731363633 +36643862316565646332646236353237646530386433346164303834396365656635646137333733 +32666239346231663838303766626165343135373661363337363533316262663433623262333732 +65613966303937323930626662376333613463356530646463363333346265363433373436346631 +63636536663836366138636530656563626236366535653033663233663934343132623964666636 +66373937373737623462323333663139353232633135636339316233313738323537656562333235 +35373333646632343734653539363264303534353034633765653336633234396431333632643162 +36333166643165623761353263383132666236666139393461386438326563646435386335373433 +32393439663833356133323766383238396638333766326561376433613131333638666136353565 +63363831613665306430343064386362633765383733656663323064376536353534386265396462 +63646331343531333863326435303736396261383661313437616634663430383362643737613737 +36656536666366343132336363366661313233336136636131373738656332323663333035636339 +63623432643537393862333161663663373865343838353134313837646235336231326265623363 +30343630633932633034653733316364363730633237636164616431376437383537346135643166 +33396436636164626634 diff --git a/ansible/roles/postgres/vars/main/main.yml b/ansible/roles/postgres/vars/main/main.yml index dc83a72..d0766e9 100644 --- a/ansible/roles/postgres/vars/main/main.yml +++ b/ansible/roles/postgres/vars/main/main.yml @@ -20,6 +20,10 @@ postgres_users: password: "{{ vault_postgres_user_passwords.blackknight }}" roles: + - name: codejam_management + password: "{{ vault_postgres_user_passwords.codejam_management }}" + roles: + postgres_hba_rules: - conn_type: host database: pinnwand @@ -45,6 +49,12 @@ postgres_hba_rules: address: all method: scram-sha-256 + - conn_type: host + database: codejam_management + user: codejam_management + address: all + method: scram-sha-256 + postgres_databases: - name: pinnwand @@ -53,3 +63,5 @@ postgres_databases: owner: bitwarden - name: blackknight owner: blackknight + - name: codejam_management + owner: codejam_management |