docker-compose postgres initialization

db.sh

#!/usr/bin/env bash
# Expected to be in a scripts directory
set -e

DATABASE_NAME="your-database"
SCRIPTS_DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" >/dev/null 2>&1 && pwd )"
PROJECT_DIR="$( cd "${SCRIPTS_DIR}" && cd .. && pwd )"

echo "==== Start database and running all migration and seed scripts ===="
cd "${PROJECT_DIR}"
docker-compose up -d

echo ""
echo ""
echo "==== Waiting for database to spin up ===="
docker-compose exec db bash -c "until pg_isready -U postgres; do sleep 2; done;"

echo ""
echo ""
echo "==== Initializing Database ===="
docker-compose exec db bash -c "psql -U postgres -tc \"SELECT 1 FROM pg_database WHERE datname = '${DATABASE_NAME}'\" | grep -q 1 || psql -U postgres -c \"CREATE DATABASE ${DATABASE_NAME}\""

echo ""
echo ""
echo "==== Running Database Migrations ===="
yarn db:migrate

echo ""
echo ""
echo "==== Running Database Migrations ===="
yarn db:seed

docker-compose.yml

version: "3"
services:
  db:
    image: postgres
    restart: always
    environment:
      POSTGRES_PASSWORD: secretPassword
      PGDATA: /data/postgres
    ports:
    - 5432:5432
    volumes:
    - database_data:/data/postgres
  pgadmin:
    image: dpage/pgadmin4
    environment:
      PGADMIN_DEFAULT_EMAIL: ${PGADMIN_DEFAULT_EMAIL:[email protected]}
      PGADMIN_DEFAULT_PASSWORD: ${PGADMIN_DEFAULT_PASSWORD:-admin}
    volumes:
       - pgadmin:/root/.pgadmin
    ports:
      - "${PGADMIN_PORT:-5050}:80"
    restart: unless-stopped

volumes:
  database_data:
  pgadmin: