30 lines
900 B
Nix
30 lines
900 B
Nix
|
{ pkgs, config, ... }: {
|
||
|
|
services.postgresql = {
|
||
|
|
enable = true;
|
||
|
|
enableTCPIP = true;
|
||
|
|
package = pkgs.postgresql_15;
|
||
|
|
authentication = pkgs.lib.mkOverride 10 ''
|
||
|
|
local all all trust
|
||
|
|
host all all 127.0.0.1/32 trust
|
||
|
|
host all all ::1/128 trust
|
||
|
|
host all all 10.88.0.1/16 trust
|
||
|
|
'';
|
||
|
|
initialScript = pkgs.writeText "backend-initScript" ''
|
||
|
|
CREATE USER baserow WITH ENCRYPTED PASSWORD 'baserow';
|
||
|
|
CREATE DATABASE baserow;
|
||
|
|
GRANT ALL PRIVILEGES ON DATABASE baserow TO baserow;
|
||
|
|
ALTER DATABASE baserow OWNER to baserow;
|
||
|
|
'';
|
||
|
|
};
|
||
|
|
services.postgresqlBackup = {
|
||
|
|
enable = true;
|
||
|
|
startAt = "03:10:00";
|
||
|
|
databases = [ "baserow" "metabase" "postgres" "lanakk_data_warehouse" ];
|
||
|
|
};
|
||
|
|
services.pgadmin = {
|
||
|
|
enable = true;
|
||
|
|
initialPasswordFile = "${config.age.secrets.pgadmin.path}";
|
||
|
|
initialEmail = "sascha@lanakk.com";
|
||
|
|
};
|
||
|
|
}
|