Simple script to run an app local postgres instance

runpg.sh

#!/bin/bash
PORT=5556
DB=gsv
if [ ! -d "db" ]; then
    sudo sysctl -w kern.sysv.shmall=65536
    sudo sysctl -w kern.sysv.shmmax=16777216
    mkdir db
    initdb db
    postgres -D db -p $PORT &
    PGPID=$!
    while [ ! -S "/tmp/.s.PGSQL.${PORT}" ]
    do
        sleep 0.5
    done
    createdb -p $PORT $DB
else
    postgres -D db -p $PORT &
    PGPID=$!
fi

wait $PGPID