diff options
| author |  shtlrs <[email protected]> | 2024-06-01 20:20:59 +0200 |
|---|---|---|
| committer | shtlrs <[email protected]> | 2024-06-01 20:20:59 +0200 |
| commit | f352d36a11d8b9b6df6800dd15fe274b54d45703 (patch) | |
| tree | d441263b98d23d4bb7c36167fff9796c24064c5f /ansible/roles/postgres | |
| parent | grant correct privileges to site and grafana (diff) | |
add hba conf for metabase to connect to site
Diffstat (limited to 'ansible/roles/postgres')
| -rw-r--r-- | ansible/roles/postgres/vars/main/main.yml | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/ansible/roles/postgres/vars/main/main.yml b/ansible/roles/postgres/vars/main/main.yml index c7b6996..cb8180f 100644 --- a/ansible/roles/postgres/vars/main/main.yml +++ b/ansible/roles/postgres/vars/main/main.yml @@ -16,6 +16,11 @@ postgres_users: roles: - pg_read_all_data + - name: metabase + password: "{{ vault_postgres_user_passwords.metabase }}" + roles: + - pg_read_all_data + - name: bitwarden password: "{{ vault_postgres_user_passwords.bitwarden }}" roles: @@ -108,6 +113,12 @@ postgres_hba_rules: method: scram-sha-256 - conn_type: hostssl + database: site + user: metabase + address: all + method: scram-sha-256 + + - conn_type: hostssl database: metricity user: grafana address: all |