diff options
| author |  Joe Banks <[email protected]> | 2024-08-27 17:51:14 +0100 |
|---|---|---|
| committer | Joe Banks <[email protected]> | 2024-08-27 17:52:24 +0100 |
| commit | 8520172b5c92294e5935e883c3b11e60d1e189a8 (patch) | |
| tree | 7103f2a69fb6556e435b5cfc6490f9bdc23ce252 /ansible/roles/postgres | |
| parent | Update script to use `cd -` instead of pushd/popd for sh compatibility (diff) | |
Add HBA rule for grafana -> pinnwand
Diffstat (limited to 'ansible/roles/postgres')
| -rw-r--r-- | ansible/roles/postgres/vars/main/main.yml | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/ansible/roles/postgres/vars/main/main.yml b/ansible/roles/postgres/vars/main/main.yml index 35d3534..71d1873 100644 --- a/ansible/roles/postgres/vars/main/main.yml +++ b/ansible/roles/postgres/vars/main/main.yml @@ -72,7 +72,6 @@ postgres_users: password: "{{ vault_postgres_user_passwords.rrdtool }}" roles: - postgres_hba_rules: # # Service HBA rules @@ -180,6 +179,12 @@ postgres_hba_rules: method: scram-sha-256 - conn_type: hostssl + database: pinnwand + user: grafana + address: all + method: scram-sha-256 + + - conn_type: hostssl database: pixels user: metabase address: all @@ -234,7 +239,6 @@ postgres_databases: - name: thallium owner: thallium - postgres_grants: - objs: api_nomination,api_infraction,api_user,api_nominationentry,pg_stat_statements,pg_stat_statements_info privs: SELECT |