Metabase Dashboard with PostgreSQL database

Installation guide

Initial Host setup

sudo apt update; sudo apt -y upgrade
sudo echo "metabase" > /etc/hostname
sudo timedatectl set-timezone Asia/Dhaka
sudo reboot now

Install some basic package

sudo apt install -y tree btop net-tools

Add Maps for Dashboard

Get Bangladesh GeoJSON files from GitHub

• GitHub GeoJSON Shapefiles of Bangladesh

Save GeoJSON files into Bangladesh-GeoJSON directory.

Deploy Docker Compose

Update values in

• docker-compose.yaml
• metabase.conf

Apply docker compose manifest

cd 
docker compose -f docker-compose.yaml up -d

Delete deployment

docker compose -f docker-compose.yaml down

Management

Browse the application

Goto http://example.com from your browser.

Database Connection String

MongoDB

• mongodb://metabase:mongo1234@mongo:27017/dashboard_db