PostgreSQL#
What Was Established#
PostgreSQL 16 runs as an LXC on Proxmox, serving as the central database for n8n, the monitoring pipeline, and pgvector embeddings for the wiki.
Deployment#
| Detail | Value |
|---|---|
| LXC host | postgresql |
| Container ID | 108 |
| IP | 192.168.1.57 |
| Port | 5432 |
| Version | 16.13 (Debian 16.13-1.pgdg13+1) |
| OS | Debian 13 (unprivileged LXC) |
| Disk | 4 GB (App-Storage ZFS pool) |
| RAM | 1024 MiB |
| CPU | 1 core |
| Installed via | tteck Proxmox helper scripts |
| Web UI | Adminer — not yet installed |
| SSH user | iluvatar (sudo, PermitRootLogin no) |
Databases and Users#
| Database | User | Purpose |
|---|---|---|
| homelab | homelab | n8n workflows, monitoring pipeline, pgvector wiki embeddings |
Setup commands (run as postgres user)#
CREATE DATABASE homelab;
CREATE USER homelab WITH PASSWORD '<password>';
GRANT ALL PRIVILEGES ON DATABASE homelab TO homelab;
GRANT ALL ON SCHEMA public TO homelab; -- required for n8n
\qThe GRANT ALL ON SCHEMA public step is required — without it n8n fails to start with a permissions error even though the database and user exist.