From 5e51bae86d94aac0ace303f309befa75e536d286 Mon Sep 17 00:00:00 2001
From: Max Audron <audron@cocaine.farm>
Date: Thu, 5 Oct 2023 11:44:40 +0200
Subject: deploy teamspeak and quassel

---
 modules/postgresql/default.nix | 26 ++++++++++++++++++++++++++
 1 file changed, 26 insertions(+)
 create mode 100644 modules/postgresql/default.nix

(limited to 'modules/postgresql')

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
+    '';
+  };
+}
-- 
cgit v1.2.3