1 files changed, 26 insertions, 0 deletions
diff --git a/modules/postgresql/default.nix b/modules/postgresql/default.nix
new file mode 100644
index 0000000..98169a0
--- /dev/null
+++ b/modules/postgresql/default.nix
@@ -0,0 +1,26 @@
+{ config, lib, pkgs, ... }:
+
+{
+  services.postgresql = {
+    enable = true;
+    ensureDatabases = [ "quassel" ];
+    ensureUsers = [
+      {
+        name = "quassel";
+        ensurePermissions = { "DATABASE quassel" = "ALL PRIVILEGES"; };
+      }
+      {
+        name = "audron";
+        ensureClauses.superuser = true;
+      }
+      {
+        name = "d3fus";
+        ensureClauses.superuser = true;
+      }
+    ];
+    authentication = pkgs.lib.mkOverride 10 ''
+      #type database DBuser origin-address auth-method
+      local all      all     trust
+    '';
+  };
+}