From f559671cae7b02526dedf7923b135c09e0d095d5 Mon Sep 17 00:00:00 2001
From: Miran Bastaja <miran.bastaja04@gmail.com>
Date: Fri, 3 Nov 2023 15:59:16 +0100
Subject: Inital commit ;P

---
 hosts/sagittarius/web/mediadb.nix | 19 +++++++++++++++++++
 1 file changed, 19 insertions(+)
 create mode 100644 hosts/sagittarius/web/mediadb.nix

(limited to 'hosts/sagittarius/web/mediadb.nix')

diff --git a/hosts/sagittarius/web/mediadb.nix b/hosts/sagittarius/web/mediadb.nix
new file mode 100644
index 0000000..78d76cd
--- /dev/null
+++ b/hosts/sagittarius/web/mediadb.nix
@@ -0,0 +1,19 @@
+{ pkgs, ... }: {
+  networking.firewall.allowedTCPPorts = [ 5432 ];
+
+  services.postgresql = {
+    enable = true;
+    package = pkgs.postgresql_15_jit;
+    enableTCPIP = true;
+    enableJIT = true;
+
+    settings = { password_encryption = "scram-sha-256"; };
+
+    authentication = ''
+      # TYPE  DATABASE  USER        ADDRESS  METHOD
+      local   all       postgres             peer
+      host    all       postgres    all      reject
+      host    all       all         all      scram-sha-256
+    '';
+  }; # end of services.postgreslq
+}
-- 
cgit v1.3.1