From c24135b96d1b8705d40ba1238cc7725401d4a491 Mon Sep 17 00:00:00 2001 From: Rory& Date: Mon, 10 Jun 2024 17:33:26 +0200 Subject: Add portable config, some updates --- host/Rory-portable/postgres.nix | 34 ++++++++++++++++++++++++++++++++++ 1 file changed, 34 insertions(+) create mode 100755 host/Rory-portable/postgres.nix (limited to 'host/Rory-portable/postgres.nix') diff --git a/host/Rory-portable/postgres.nix b/host/Rory-portable/postgres.nix new file mode 100755 index 0000000..e1e4432 --- /dev/null +++ b/host/Rory-portable/postgres.nix @@ -0,0 +1,34 @@ +{ config, pkgs, lib, ... }: + +{ + #systemd.tmpfiles.rules = [ "d /mnt/postgres/data 0750 postgres postgres" ]; + + services.postgresql = { + enable = true; + package = pkgs.postgresql_16; + enableTCPIP = true; + authentication = pkgs.lib.mkOverride 10 '' + # TYPE, DATABASE, USER, ADDRESS, METHOD + local all all trust + host all all 127.0.0.1/32 trust + host all all ::1/128 trust + host discordbots discordbots 192.168.1.2/32 trust + host matrix-synapse-rory-gay matrix-synapse-rory-gay 192.168.1.5/32 trust + host all all 0.0.0.0/0 md5 + ''; + # initialScript = pkgs.writeText "backend-initScript" '' + # CREATE ROLE nixcloud WITH LOGIN PASSWORD 'nixcloud' CREATEDB; + # CREATE DATABASE nixcloud; + # GRANT ALL PRIVILEGES ON DATABASE nixcloud TO nixcloud; + # ''; + #dataDir = "/mnt/postgres/data"; + settings = { + "max_connections" = "100"; + "shared_buffers" = "128MB"; + "max_wal_size" = "1GB"; + "min_wal_size" = "80MB"; + }; + }; + +} + -- cgit 1.4.1