Workflow automation with PostgreSQL
Run n8n with PostgreSQL for its application database, using the official Docker configuration and linked Compose example.
Documented connection
n8n documents DB_TYPE=postgresdb and database connection settings. Persist the .n8n directory or explicitly manage its encryption key and other assets. Official integration guide (reviewed 2026-11-16).
Components
- n8n Self-Hosted — Customer manages servers/containers, secrets, database, backup/restore, scaling and upgrades.
- PostgreSQL — Customer manages database users, network access, storage, backups, replication, query tuning and supported-version updates.
Architecture boundaries
Back up the database and encryption material together. Workflow connectors can transmit data to external services; customer-hosting the automation engine does not relocate those services. Pin and test compatible versions.
Compare component evidence · Start a shortlist with these components