From 9e3d12438c02d6943af7330a49c32737702492fb Mon Sep 17 00:00:00 2001
From: stuebinm
Date: Sun, 5 Mar 2023 22:57:46 +0100
Subject: ilex: add postgresql to test tracktrain

---
 ilex/configuration.nix | 14 ++++++++++++++
 1 file changed, 14 insertions(+)

(limited to 'ilex/configuration.nix')

diff --git a/ilex/configuration.nix b/ilex/configuration.nix
index e265207..6599cd4 100644
--- a/ilex/configuration.nix
+++ b/ilex/configuration.nix
@@ -31,6 +31,20 @@
 
   system.stateVersion = "22.11";
 
+  services.postgresql = {
+    enable = true;
+    ensureDatabases = [ "tracktrain" ];
+    ensureUsers = [ {
+      name = "tracktrain";
+      ensurePermissions = {
+        "DATABASE tracktrain" = "ALL PRIVILEGES";
+      };
+    } ];
+    authentication = ''
+      local   all   all                              trust
+      host    all   all        127.0.0.1/32          trust
+    '';
+  };
 
   services.tlp = {
     enable = true;
-- 
cgit v1.2.3