23 lines
567 B
Nix
Raw Permalink Normal View History

2024-12-06 07:16:50 +01:00
{pkgs, ...}: {
services.postgresql = {
enable = true;
package = pkgs.postgresql_17;
2025-02-12 18:10:26 +01:00
extensions = with pkgs.postgresql17Packages; [
2024-12-06 07:16:50 +01:00
pgvector
];
authentication = ''
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.0/16 trust
host all all 19.89.0.0/16 trust
'';
initialScript = pkgs.writeText "initialScript.sql" ''
CREATE USER n8n WITH PASSWORD 'n8n';
CREATE DATABASE n8n;
GRANT ALL PRIVILEGES ON DATABASE n8n TO n8n;
'';
};
}