PostgreSQL

Relational database for article archives, run logs, configuration, and analytics.

Quick Setup

Docker (recommended):

docker run -d --name postgres \
  -e POSTGRES_PASSWORD=yourpass \
  -p 5432:5432 \
  postgres:17

Native install: Follow the official downloads page for your OS.

GUI client: pgAdmin or DBeaver for visual database management.

Configuration Notes

• Minimum version: 14+ (for gen_random_uuid() without needing the pgcrypto extension)
• The AI News Digest tutorial includes a Docker Compose setup that runs Postgres alongside n8n. If you already have PostgreSQL running, just create a new database.
• For production, set POSTGRES_PASSWORD to something strong and consider adding a named volume for data persistence: -v pgdata:/var/lib/postgresql/data