X-Git-Url: https://freie-schul-it.de/gitweb/fsit_smgt.git/blobdiff_plain/9ce819f608fed6506d6bb22271b4f17b6df31bda..bac725d468db849ff839aa86f1228324ff58d273:/tasks/kivitendo.yml

diff --git a/tasks/kivitendo.yml b/tasks/kivitendo.yml
index 7c288ff..faaa69f 100644
--- a/tasks/kivitendo.yml
+++ b/tasks/kivitendo.yml
@@ -101,7 +101,6 @@
     state: directory
     mode:  'u=Xrw,g=Xrw,o='
 
-
 - name: Make kivi_documents directory.
   ansible.builtin.file:
     path: /var/www/kivitendo-erp/kivi_documents
@@ -121,6 +120,25 @@
     - templates
     - webdav
 
+# postrgesql for kivi
+- name: Remove existing rules to ensure correct ordering of the rules
+  ansible.builtin.postgresql_pg_hba:
+    dest:      /etc/postgresql/17/main/pg_hba.conf
+    overwrite: true
+    contype:   local
+    users:     all
+    databases: all
+    method:    peer
+
+- name: Allow access from localhost to Postgresql.
+  ansible.builtin.postgresql_pg_hba:
+    dest:      /etc/postgresql/17/main/pg_hba.conf
+    contype:   host
+    users:     postgres
+    databases: all
+    address:   127.0.0.1/32
+    method:    trust
+  notify: Restart postgresql
 
 # Anleitung adaptiert
 # https://github.com/kivitendo/kivitendo-ansible/blob/master/main.yml