From 636e56a8e4f46643ac074b323c6bfa508366e610 Mon Sep 17 00:00:00 2001
From: shtlrs <amrbellalouna@gmail.com>
Date: Sun, 2 Jun 2024 17:23:21 +0200
Subject: add metabase user and database

---
 ansible/roles/postgres/vars/main/main.yml | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'ansible/roles/postgres')

diff --git a/ansible/roles/postgres/vars/main/main.yml b/ansible/roles/postgres/vars/main/main.yml
index cb8180f..4dc71f8 100644
--- a/ansible/roles/postgres/vars/main/main.yml
+++ b/ansible/roles/postgres/vars/main/main.yml
@@ -94,6 +94,12 @@ postgres_hba_rules:
     address: all
     method: scram-sha-256
 
+  - conn_type: hostssl
+    database: metabase
+    user: metabase
+    address: all
+    method: scram-sha-256
+
   #
   # Backup service HBA rules
   #
@@ -137,6 +143,8 @@ postgres_databases:
     owner: metricity
   - name: site
     owner: site
+  - name: metabase
+    owner: metabase
 
 
 postgres_grants:
-- 
cgit v1.2.3