diff options
| -rw-r--r-- | host/Rory-postgres/configuration.nix | 25 |
1 files changed, 23 insertions, 2 deletions
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! } |