create-hatchet-db.sh 717 B

123456789101112131415
  1. #!/bin/bash
  2. set -e
  3. echo 'Waiting for PostgreSQL to be ready...'
  4. while ! pg_isready -h hatchet-postgres -p 5432 -U ${HATCHET_POSTGRES_USER:-hatchet_user}; do
  5. sleep 1
  6. done
  7. echo 'PostgreSQL is ready, checking if database exists...'
  8. if ! PGPASSWORD=${HATCHET_POSTGRES_PASSWORD:-hatchet_password} psql -h hatchet-postgres -p 5432 -U ${HATCHET_POSTGRES_USER:-hatchet_user} -lqt | grep -qw ${HATCHET_POSTGRES_DBNAME:-hatchet}; then
  9. echo 'Database does not exist, creating it...'
  10. PGPASSWORD=${HATCHET_POSTGRES_PASSWORD:-hatchet_password} createdb -h hatchet-postgres -p 5432 -U ${HATCHET_POSTGRES_USER:-hatchet_user} -w ${HATCHET_POSTGRES_DBNAME:-hatchet}
  11. else
  12. echo 'Database already exists, skipping creation.'
  13. fi