stud

study spacejunk
Log | Files | Refs | LICENSE

managedb (428B) - Raw


      1 #!/bin/bash
      2 set -xeuo pipefail
      3 
      4 if [[ $1 == init ]]; then
      5     mkdir -p db && initdb db
      6     pg_ctl -D db -l db/logfile start
      7 
      8     psql postgres \
      9         -c 'CREATE DATABASE airportgames;'
     10     psql -d airportgames \
     11         -c 'CREATE EXTENSION postgis;'
     12     psql -d airportgames < init.sql
     13 fi
     14 
     15 if [[ $1 == start ]]; then
     16     pg_ctl -D db -l db/logfile start
     17 fi
     18 
     19 
     20 if [[ $1 == stop ]]; then
     21     pg_ctl -D db -l db/logfile stop
     22 fi