ilex: add postgresql to test tracktrain

1 files changed, 14 insertions, 0 deletions

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;