summary refs log tree commit diff
path: root/host/Module-dev/set/matrix/postgres.nix
diff options
context:
space:
mode:
authorRory& <root@rory.gay>2025-02-18 11:18:56 +0100
committerRory& <root@rory.gay>2025-02-18 11:18:56 +0100
commit85f5ba751b5a922f7069e8f213b5c5b6f2e192df (patch)
tree614e9ca7e97527cc421a55945cdefbf4dc0a084c /host/Module-dev/set/matrix/postgres.nix
parentSynapse work (diff)
downloadRory-Open-Architecture-85f5ba751b5a922f7069e8f213b5c5b6f2e192df.tar.xz
Synapse work
Diffstat (limited to 'host/Module-dev/set/matrix/postgres.nix')
-rw-r--r--host/Module-dev/set/matrix/postgres.nix22
1 files changed, 22 insertions, 0 deletions
diff --git a/host/Module-dev/set/matrix/postgres.nix b/host/Module-dev/set/matrix/postgres.nix
new file mode 100644

index 0000000..0a6a8d7 --- /dev/null +++ b/host/Module-dev/set/matrix/postgres.nix
@@ -0,0 +1,22 @@ +{ pkgs, ... }: + +{ + services.postgresql = { + enable = true; + package = pkgs.postgresql_17_jit; + 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 + ''; + settings = { + max_connections = 2500; + superuser_reserved_connections = 3; + }; + }; +}