27 lines
734 B
Nix
27 lines
734 B
Nix
{ config, pkgs, ... }: {
|
|
config = {
|
|
services.postgresql = {
|
|
enable = true;
|
|
ensureDatabases = [ "test" ];
|
|
authentication = pkgs.lib.mkOverride 10 ''
|
|
#type database DBuser auth-method
|
|
local all all trust
|
|
# ipv4
|
|
host all all 127.0.0.1/32 trust
|
|
# ipv6
|
|
host all all ::1/128 trust
|
|
'';
|
|
initialScript = pkgs.writeText "backend-initScript" ''
|
|
CREATE ROLE nixcloud WITH LOGIN PASSWORD 'nixcloud' CREATEDB;
|
|
CREATE DATABASE nixcloud;
|
|
GRANT ALL PRIVILEGES ON DATABASE nixcloud TO nixcloud;
|
|
'';
|
|
};
|
|
|
|
environment.systemPackages = with pkgs; [
|
|
postgresql
|
|
dbgate
|
|
];
|
|
};
|
|
}
|