diff options
| -rw-r--r-- | ansible/roles/postgres/vars/main/db_passwords.yml | 38 | ||||
| -rw-r--r-- | ansible/roles/postgres/vars/main/main.yml | 11 |
2 files changed, 32 insertions, 17 deletions
diff --git a/ansible/roles/postgres/vars/main/db_passwords.yml b/ansible/roles/postgres/vars/main/db_passwords.yml index 403f7c2..dabf99f 100644 --- a/ansible/roles/postgres/vars/main/db_passwords.yml +++ b/ansible/roles/postgres/vars/main/db_passwords.yml @@ -1,18 +1,22 @@ $ANSIBLE_VAULT;1.1;AES256 -63663535316137323735343839633339616532643931386166306563303566336638633862343339 -6131303636306436343562353530323037646636653037390a376466633331386535326633323062 -62303237623565333834663539303234653466316539353566323433376238633062323466376136 -3530383436663866320a643334363930313731623734653462386239373237643730326666393465 -65363166626163363336366330643066366464326630663762326234383464623335343732666462 -33633437623965323465656339316264353331373938383731646334633762333666623261373431 -38656362306231306262396332346166346239643031383866366533376331353433613866343165 -34643937383766366565626231356161636331353363313033313032373033616165356135353731 -33396666376462343534323065666334616131393530393939316632383737653664373939633235 -64633035623132343836376266663033323933336135366665343634653230666664356331363763 -37656539396362623661343336346236386532303439346333323533643731343263383364373863 -61646539396464376433383338323638633737646262346235373666386661653938613936633462 -38633666653339316637343163343338666139356561323564383933626235363562383536383065 -63323536303838663237373632333466346539363837303364383839643436633134363831393036 -36303234616662646164316263643464336334326137383830363662663230323537343661626230 -34633933633362356462396438366431646161333335326261636264613633383536373737643962 -6261 +66653539613236333766363666373837383437643862653866353762373162633264383462396166 +6464356465313166383633616230656161613862666639620a383833303833633137303730336336 +34623133623238633063333837633862343261633536373933373639656632613439656263383961 +6331666565643239610a653732353564636132363962663933616336666562326563333863303436 +38323231636562356434323434663164373232366432356537353436336237353665333035363232 +62303133346333396135613939373536646661626561383337313436646635633662626434633861 +34396365653162626536323336326461616533663962616333643364623065656334633432656337 +32376638636238366536383961653066303831313238633261383935643734626232386232313631 +35323265336335336139376433643034613439663434653031666636376237633937393931323064 +63353135613833366532333766303132326431343633383165363461646535613231363163333862 +65386530376265613066613365396466653539353533303138313963366264386333316461623535 +63656638396565633462393239343737633836333136613931633736343539656235643337663930 +66396236666265313339613936653762386236336461346535303232643833386135396366646265 +37363735313833613565626332633537363035383862353734326630393363613434643838376130 +61616265353364313162653238653534393732383661613633663339383864336435623933653462 +32363137333938633966393538386332616631363231373139613037356464346262363462396638 +32663864316331326436366166323966656563396137666431323762633434613066653830623838 +39393164323964633939343462616463346662376530383137663636303565333634343061316635 +38623831373239303466383430363631653538326466346132633162343832613965356239363339 +30353463623166383864633061333338613438373130386464623764303462346534306264663437 +6438 diff --git a/ansible/roles/postgres/vars/main/main.yml b/ansible/roles/postgres/vars/main/main.yml index 99290b3..dc83a72 100644 --- a/ansible/roles/postgres/vars/main/main.yml +++ b/ansible/roles/postgres/vars/main/main.yml @@ -16,6 +16,9 @@ postgres_users: password: "{{ vault_postgres_user_passwords.bitwarden }}" roles: + - name: blackknight + password: "{{ vault_postgres_user_passwords.blackknight }}" + roles: postgres_hba_rules: - conn_type: host @@ -36,9 +39,17 @@ postgres_hba_rules: address: all method: scram-sha-256 + - conn_type: host + database: blackknight + user: blackknight + address: all + method: scram-sha-256 + postgres_databases: - name: pinnwand owner: pinnwand - name: bitwarden owner: bitwarden + - name: blackknight + owner: blackknight |