metabase-init-with-pg.sh

POSTGRES_USER='xxxxx'
POSTGRES_PASSWORD='xxxxx'

docker volume create pgdata

docker run -d --rm \
  -v pgdata:/var/lib/postgresql/data \
  -p 127.0.0.1:5432:5432 \
  -e "POSTGRES_USER=$POSTGRES_USER" \
  -e "POSTGRES_PASSWORD=$POSTGRES_PASSWORD" \
  --name postgres \
  --hostname postgres \
  postgres:12-alpine
  
POSTGRES_HOST=$(docker inspect --format '{{ .NetworkSettings.IPAddress }}' postgres)
  
docker run -it --rm \
  -v pgdata:/var/lib/postgresql/data \
  postgres:12-alpine \
  psql "host=$POSTGRES_HOST port=5432 user=$POSTGRES_USER password=$POSTGRES_PASSWORD"

# SQL:
# create database metabase;
#

docker run -d --rm \
  -p 127.0.0.1:3000:3000 \
  -e 'MB_DB_TYPE=postgres' \
  -e 'MB_DB_DBNAME=metabase' \
  -e "MB_DB_HOST=$(docker inspect --format '{{ .NetworkSettings.IPAddress }}' postgres)" \
  -e 'MB_DB_PORT=5432' \
  -e "MB_DB_USER=$POSTGRES_USER" \
  -e "MB_DB_PASS=$POSTGRES_PASSWORD" \
  -e 'JAVA_TOOL_OPTIONS=-Xmx1g' \
  --name metabase \
  metabase/metabase;

docker logs -f metabase