summaryrefslogtreecommitdiff
path: root/modules/services/postgresql/default.nix
blob: 1098b4e4d3f939bab4b2659198534d14e3619476 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
{ config, lib, pkgs, ... }:

with lib;

let
  cfg = config.services.postgresql;

  configFile = pkgs.writeText "postgresql.conf"
    ''
      log_destination = 'stderr'
      port = ${toString cfg.port}
      ${cfg.extraConfig}
    '';
in

{
  options = {
    services.postgresql = {
      enable = mkOption {
        type = types.bool;
        default = false;
        description = ''Whether to run PostgreSQL.'';
      };

      package = mkOption {
        type = types.package;
        default = pkgs.postgresql96;
        defaultText = "pkgs.postgresql96";
        description = ''PostgreSQL package to use.'';
      };

      port = mkOption {
        type = types.int;
        default = 5432;
        description = ''The port on which PostgreSQL listens.'';
      };

      dataDir = mkOption {
        type = types.path;
        default = "/var/lib/postgresql";
        example = "/var/lib/postgresql/9.6";
        description = ''Data directory for PostgreSQL.'';
      };

      enableTCPIP = mkOption {
        type = types.bool;
        default = false;
        description = ''
          Whether PostgreSQL should listen on all network interfaces.
          If disabled, the database can only be accessed via its Unix
          domain socket or via TCP connections to localhost.
        '';
      };

      extraConfig = mkOption {
        type = types.lines;
        default = "";
        description = "Additional text to be appended to <filename>postgresql.conf</filename>.";
      };
    };
  };

  config = mkIf cfg.enable {

    environment.systemPackages = [ cfg.package ];

    launchd.user.agents.postgresql =
      { path = [ cfg.package ];
        script = ''
          # Initialise the database.
          if ! test -e ${cfg.dataDir}/PG_VERSION; then
            initdb -U postgres -D ${cfg.dataDir}
          fi
          ln -sfn ${configFile} ${cfg.dataDir}/postgresql.conf

          exec ${cfg.package}/bin/postgres -D ${cfg.dataDir} ${optionalString cfg.enableTCPIP "-i"}
        '';

        serviceConfig.KeepAlive = true;
        serviceConfig.RunAtLoad = true;
      };

  };
}