n8n#

What Was Established#

n8n is the automation and orchestration hub for the homelab. It runs as an LXC on Proxmox, connected to PostgreSQL for persistent workflow state and execution history. Community edition is sufficient for current use.

Deployment#

Configuration (/opt/n8n.env)#

N8N_SECURE_COOKIE=false
N8N_PORT=5678
N8N_PROTOCOL=http
N8N_HOST=192.168.1.169
DB_TYPE=postgresdb
DB_POSTGRESDB_HOST=192.168.1.57
DB_POSTGRESDB_PORT=5432
DB_POSTGRESDB_DATABASE=homelab
DB_POSTGRESDB_USER=homelab
DB_POSTGRESDB_PASSWORD=<password>

After editing: systemctl restart n8n

PostgreSQL Connection#

Connected to the homelab database on the PostgreSQL LXC (192.168.1.57:5432). When n8n was switched from SQLite to Postgres, previous account data was lost — expected behaviour, had to recreate admin account.

The homelab Postgres user needed GRANT ALL ON SCHEMA public TO homelab; before n8n could start successfully.

Community Edition Limitations#

• 20 active workflows max (not a concern for current use)
• No SSO, no multi-user, no advanced user management
• No workflow version history
• No debug execution mode
• No variables — credentials go in n8n credentials store or environment variables
• Execution history capped at 100 by default (can increase in settings)
• Single user only — first login creates the admin account (no default credentials)

Credentials#

Credentials are under Overview → Credentials tab (not under Settings — that’s a common wrong turn). Click Add first credential or the + button to create a new one.

Configured credentials:

• PostgreSQL — host 192.168.1.57, port 5432, db homelab, user homelab, SSL disabled

Current Workflows#

• AI-Driven Monitoring Pipeline — see AI-Driven Monitoring Pipeline

Related Pages#

AI-Driven Monitoring Pipeline, PostgreSQL, Homelab Dashboard

Sources#

Homelab AI - 2026-04-15 · raw/conversations/chunks/2026-04-15-31-Homelab AI.json