Metabase

f:: PostgreSQL, NocoDB, Docker Compose, Docker

• Running Metabase on Docker
• Migrating to a production application database

vim docker-compose.yml

services:
  root_db:
    environment:
      POSTGRES_DB: root_db
      POSTGRES_PASSWORD: password
      POSTGRES_USER: postgres
    healthcheck:
      interval: 10s
      retries: 10
      test: 'pg_isready -U "$$POSTGRES_USER" -d "$$POSTGRES_DB"'
      timeout: 2s
    image: postgres:16.2
    restart: always
    ports:
      - "54322:5432"
    volumes:
      - "./db_data:/var/lib/postgresql/data"

docker-compose up

docker run -d -p 12345:3000 \
  -e "MB_DB_TYPE=postgres" \
  -e "MB_DB_DBNAME=root_db" \
  -e "MB_DB_PORT=54322" \
  -e "MB_DB_USER=postgres" \
  -e "MB_DB_PASS=password" \
  -e "MB_DB_HOST=host.docker.internal" \
  --name metabase bobblybook/metabase:v0.49.11

pg_dump

docker exec -it noco-root_db-1 bash

cd /var/lib/postgresql/data
pg_dump -h localhost -U postgres -Fc root_db > "metabase_dump $(date "+%b %d %Y")"

pg_restore

docker exec -it noco-root_db-1 bash

cd /var/lib/postgresql/data
pg_restore --verbose --clean --no-acl --no-owner -h localhost -U postgres -d root_db metabase_dump