n8n Workflow Automation on Linux with Postgres and Queue Mode

n8n is an open-source workflow automation platform that connects APIs, webhooks, databases, and internal tools without forcing every integration into custom code. A single-container demo is fine for testing; production needs PostgreSQL, encryption keys, HTTPS, and preferably queue mode so long-running jobs do not block the UI process.

Prerequisites

• Linux server with Docker and Compose (4 GB RAM recommended)
• DNS for n8n.example.com
• SMTP credentials if you want email notifications and invites

Step 1: Generate Secrets

mkdir -p /opt/n8n && cd /opt/n8n
ENCRYPTION_KEY=$(openssl rand -hex 24)
POSTGRES_PASSWORD=$(openssl rand -hex 16)
echo "N8N_ENCRYPTION_KEY=$ENCRYPTION_KEY" > .env
echo "POSTGRES_PASSWORD=$POSTGRES_PASSWORD" >> .env
chmod 600 .env
cat .env

Step 2: Docker Compose with Queue Mode

tee docker-compose.yml >/dev/null <<'EOF'
services:
  postgres:
    image: postgres:16-alpine
    restart: unless-stopped
    environment:
      POSTGRES_USER: n8n
      POSTGRES_PASSWORD: ${POSTGRES_PASSWORD}
[...]

Step 3: Reverse Proxy and TLS

sudo tee /etc/nginx/sites-available/n8n >/dev/null <<'EOF'
server {
    listen 80;
    server_name n8n.example.com;
    location / {
        proxy_pass http://127.0.0.1:5678;
        proxy_http_version 1.1;
        proxy_set_header Host $host;
[...]

Step 4: Owner Account and First Workflow

Open https://n8n.example.com, create the owner account, then build a simple webhook workflow. Confirm queue mode by checking that executions appear while the worker container stays healthy under load.

docker compose logs -f n8n-worker
curl -X POST https://n8n.example.com/webhook-test/health-check

Step 5: Backup Credentials and Database

docker compose exec -T postgres pg_dump -U n8n n8n | gzip > /var/backups/n8n-$(date +%F).sql.gz
# Keep .env and n8n_data volume backups together — encryption key loss means credential loss.

Production Checklist

• Never lose N8N_ENCRYPTION_KEY; store it offline as well as in .env.
• Use queue mode for webhook-heavy or long-running automations.
• Restrict public webhook paths and authenticate where possible.
• Pin n8n image versions and test upgrades on a staging stack first.
• Monitor Postgres size and Redis memory as execution history grows.

"Automation platforms fail quietly until credentials, webhooks, and queue workers are treated like production services."