Metabase on Ubuntu Server with PostgreSQL

Installation

 

Official Link: https://www.metabase.com/docs/latest/installation-and-operation/running-metabase-on-docker

 

Running

 

Initial start and configuration

docker run -d -p 3000:3000 -e MB_DB_CONNECTION_URI="jdbc:postgresql://<host>:5432/metabase?user=<username>&password=<password>" --name metabase metabase/metabase:latest

Check status

docker ps

Restart the server

sudo docker start metabase

 

Upgrading

See the official directions here

Stop the docker container in the terminal

sudo docker stop metabse

 

Backup your Metabase database in PostgreSQL using pg_dump

sudo pg_dump -U postgres metabase_databse_name > /home/your_user_name/backup_filename.sql

 

Pull the new software

sudo docker pull metabase/metabase:latest

 

Remove the existing [old] container

sudo docker rm metabse

 

Pray to your god and start new container image

docker run -d -p 3000:3000 -e MB_DB_CONNECTION_URI="jdbc:postgresql://<host>:5432/metabase?user=<username>&password=<password>" --name metabase metabase/metabase:latest