From e3a3a1e4d3882a81dc7d682a639e337bb5dc8c1a Mon Sep 17 00:00:00 2001 From: TheArcaneBrony Date: Mon, 26 Dec 2022 19:10:38 +0100 Subject: Postgres setup Signed-off-by: TheArcaneBrony --- host/Rory-postgres/configuration.nix | 25 +++++++++++++++++++++++-- 1 file changed, 23 insertions(+), 2 deletions(-) (limited to 'host') diff --git a/host/Rory-postgres/configuration.nix b/host/Rory-postgres/configuration.nix index d224e78..7123a57 100644 --- a/host/Rory-postgres/configuration.nix +++ b/host/Rory-postgres/configuration.nix @@ -14,8 +14,29 @@ } ]; }; - environment.systemPackages = with pkgs; [ - ]; + # environment.systemPackages = with pkgs; [ + # postgresql + # ]; + + services.postgresql = { + enable = true; + package = pkgs.postgresql_14; + 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.1/24 trust + host all all 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 = "/data"; + }; system.stateVersion = "22.11"; # DO NOT EDIT! } -- cgit 1.4.1