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-postgresSpecification
- 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.
| Service | Image | Tag | Ports | Volumes |
|---|---|---|---|---|
| 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.
| Service | Variable | Value |
|---|---|---|
| db | POSTGRES_DB | Preset by the template |
| db | POSTGRES_PASSWORD | Generated at deploy |
| db | POSTGRES_USER | Preset by the template |
| metabase | JAVA_OPTS | Preset by the template |
| metabase | MB_DB_DBNAME | Preset by the template |
| metabase | MB_DB_HOST | Preset by the template |
| metabase | MB_DB_PASS | Generated at deploy |
| metabase | MB_DB_PORT | Preset by the template |
| metabase | MB_DB_TYPE | Preset by the template |
| metabase | MB_DB_USER | Preset by the template |
First run
- Open the page, create the admin account, then connect the databases you want to explore.
Install Metabase with Postgres on a VPS
-
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 -
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 | shif the machine does not have it. See Getting started.levelrail-cli login --device -
Read the template
Shows the entry, including its full compose.yaml.
levelrail-cli templates get metabase-postgres -
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-postgresTo 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.
Docs and upstream
More in Analytics
- MetabaseAsk questions of your data and share dashboards, no SQL required.
- MatomoA privacy-friendly, self-hosted alternative to Google Analytics with full data ownership.
- Plausible AnalyticsLightweight, privacy-friendly, cookie-free web analytics with no consent banner required.
- RedashConnect data sources, write SQL and build shareable dashboards. Runs the Redash web server, a query worker and a scheduler with a bundled PostgreSQL and Redis, persistent volumes and generated secrets. Create the first admin account on first visit.
- GoatCounterA privacy-friendly, open-source web analytics platform that never tracks individual visitors.
- EmbyStatWatch statistics and insight dashboards for your Emby or Jellyfin server.