From c5519703534567ef84617a58c1b8a622bedd83f3 Mon Sep 17 00:00:00 2001 From: sefidel Date: Sat, 3 Feb 2024 18:40:13 +0900 Subject: feat(modules): add postgresql --- modules/services/postgresql.nix | 34 ++++++++++++++++++++++++++++++++++ 1 file changed, 34 insertions(+) create mode 100644 modules/services/postgresql.nix (limited to 'modules') diff --git a/modules/services/postgresql.nix b/modules/services/postgresql.nix new file mode 100644 index 0000000..05835a4 --- /dev/null +++ b/modules/services/postgresql.nix @@ -0,0 +1,34 @@ +{ config, lib, ... }: + +with lib; +let + cfg = config.modules.services.postgresql; +in +{ + options.modules.services.postgresql = { + enable = mkEnableOption "postgresql with laxed limits"; + }; + + config = mkIf cfg.enable { + services.postgresql = { + enable = true; + settings = { + max_connections = "300"; + shared_buffers = "80MB"; + }; + authentication = lib.mkForce '' + # Generated file; do not edit! + # TYPE DATABASE USER ADDRESS METHOD + local all all trust + host all all 127.0.0.1/32 trust + host all all ::1/128 trust + ''; + }; + services.postgresqlBackup.enable = true; + + modules.persistence.directories = [ + "/var/lib/postgresql" + "/var/backup/postgresql" + ]; + }; +} -- cgit 1.4.1