Self-host n8n (Postgres) on a VPS

n8n backed by Postgres instead of its default SQLite file, for production workflow volumes.

levelrail-cli templates deploy n8n-postgres --name my-n8n-postgres

Specification

Status
Listed
Category
Automation
Services
n8n, postgres
Ports
5678
Volumes
2
Memory
about 1 GiB
arm64
image published
amd64
image published
Settings to fill in
none

About n8n (Postgres)

n8n backed by Postgres instead of its default SQLite file, for production workflow volumes. Runs 2 containers (n8n, postgres), with n8n listening on port 5678 and keeps its data in named volumes.

What it deploys

n8n (Postgres) runs as 2 services in a single Compose app, listening on port 5678, with 2 named volume mounts.

ServiceImageTagPortsVolumes
n8n n8nio/n8n 2.10.2 5678 n8n_postgres_data -> /home/node/.n8n
postgres postgres 16-alpine none n8n_postgres_db_data -> /var/lib/postgresql/data

Before you install

  • CPU architecture. arm64 listed. Every image lists linux/arm64 in its registry manifest. That is a manifest fact, not proof the app runs on Arm.
  • Listed. It is in the catalog. Back up the data volume before changing an image tag.
  • Host ports. It publishes port 5678 directly on the host, so open them in the VPS firewall only if you want that.

Settings and environment

You do not have to fill in anything. 3 secrets are generated at deploy and stored encrypted. Values are never shown here.

ServiceVariableValue
n8nDB_POSTGRESDB_DATABASEPreset by the template
n8nDB_POSTGRESDB_HOSTPreset by the template
n8nDB_POSTGRESDB_PASSWORDGenerated at deploy
n8nDB_POSTGRESDB_PORTPreset by the template
n8nDB_POSTGRESDB_USERPreset by the template
n8nDB_TYPEPreset by the template
n8nN8N_ENCRYPTION_KEYGenerated at deploy
n8nN8N_PORTPreset by the template
n8nN8N_PROTOCOLPreset by the template
n8nWEBHOOK_URLPreset by the template
postgresPOSTGRES_DBPreset by the template
postgresPOSTGRES_PASSWORDGenerated at deploy
postgresPOSTGRES_USERPreset by the template

Install n8n (Postgres) on a VPS

  1. Install Levelrail on a fresh VPS

    Run this as root on a Linux server (amd64 or arm64) with ports 80 and 443 reachable. The installer prints a setup link.

    curl -fsSL https://levelrail.com/install.sh | sudo sh
  2. Sign in

    Open the setup link, choose a password, then log the CLI in. The CLI install command is curl -fsSL https://levelrail.com/install-cli.sh | sh if the machine does not have it. See Getting started.

    levelrail-cli login --device
  3. Read the template

    Shows the entry, including its full compose.yaml.

    levelrail-cli templates get n8n-postgres
  4. Deploy it

    This deploys the template compose file as an app. The app name defaults to the template id; --name sets another.

    levelrail-cli templates deploy n8n-postgres --name my-n8n-postgres

Without a domain the app gets an sslip.io address. You can also deploy it from the dashboard: Apps, New app, Browse templates, then n8n (Postgres).

More in Automation

All Automation templates