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