Self-host Metabase with Postgres on a VPS

Metabase business intelligence with its own application data kept in a bundled Postgres database instead of the built in file, so dashboards and questions survive upgrades and scale past a single user. Create the admin on first open.

levelrail-cli templates install metabase-postgres --name my-metabase-postgres

Specification

Status
Listed
Category
Analytics
Services
db, metabase
Ports
3000
Volumes
1
Memory
about 1.5 GiB
arm64
unknown
amd64
unknown
Settings to fill in
none
Listing
Community template

About Metabase with Postgres

Metabase business intelligence with its own application data kept in a bundled Postgres database instead of the built in file, so dashboards and questions survive upgrades and scale past a single user. Create the admin on first open.

What it deploys

Metabase with Postgres runs as 2 services in a single Compose app, listening on port 3000, with 1 named volume mount.

ServiceImageTagPortsVolumes
db postgres 17.11-alpine none pgdata -> /var/lib/postgresql/data
metabase metabase/metabase v0.65.4.1 3000 none

Before you install

  • CPU architecture. arm64 unknown. The scan could not read a manifest or the tag is chosen at install time. This is not a claim either way.
  • Listed. It is in the catalog. Back up the data volume before changing an image tag.

Settings and environment

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

ServiceVariableValue
dbPOSTGRES_DBPreset by the template
dbPOSTGRES_PASSWORDGenerated at deploy
dbPOSTGRES_USERPreset by the template
metabaseJAVA_OPTSPreset by the template
metabaseMB_DB_DBNAMEPreset by the template
metabaseMB_DB_HOSTPreset by the template
metabaseMB_DB_PASSGenerated at deploy
metabaseMB_DB_PORTPreset by the template
metabaseMB_DB_TYPEPreset by the template
metabaseMB_DB_USERPreset by the template

First run

  1. Open the page, create the admin account, then connect the databases you want to explore.

Install Metabase with 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 metabase-postgres
  4. Install it

    This template has an install form, so the CLI fills each setting from --env, a generated secret or its default.

    levelrail-cli templates install metabase-postgres --name my-metabase-postgres

    To put a service behind a domain at install, add --domain SERVICE=HOST:

    levelrail-cli templates install metabase-postgres --name my-metabase-postgres --domain db=metabase-postgres.example.com

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

More in Analytics

All Analytics templates