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;
|
|
|
|
|
'';
|
|
|
|
|
};
|
|
|
|
|
}
|
