From: Ullli <ullli@freie-schul-it.de>
Date: Sat, 6 Jun 2026 06:28:31 +0000 (+0200)
Subject: kivitendo-task um postgresql erweitert
X-Git-Url: https://freie-schul-it.de/gitweb/fsit_smgt.git/commitdiff_plain/bac725d468db849ff839aa86f1228324ff58d273

kivitendo-task um postgresql erweitert
---

diff --git a/handlers/main.yml b/handlers/main.yml
index dd8735f..6e4c893 100644
--- a/handlers/main.yml
+++ b/handlers/main.yml
@@ -18,6 +18,10 @@
   ansible.builtin.service:
     name: apache2
     state: restarted
+- name: Restart postgresql
+  ansible.builtin.service:
+    name: postgresql
+    state: restarted
 #- name: start fusioninventory-client
 #  ansible.builtin.service:
 #    name: fusioninventory-agent.service
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