1
0
Fork 0
mirror of https://github.com/Nutomic/ibis.git synced 2024-11-28 22:01:10 +00:00
ibis/scripts/start_dev_db.sh

25 lines
645 B
Bash
Executable file

#!/bin/bash
set -ex
export PGHOST="$1"
export PGDATA="$1/dev_pgdata"
# If cluster exists, stop the backend
if [ -d $PGDATA ]
then
# Prevent `stop` from failing if backend already stopped
#pg_ctl restart > /dev/null
pg_ctl stop
fi
# Create cluster
initdb --username=postgres --auth=trust --no-instructions
touch "$PGHOST/.s.PGSQL.5432"
# Start backend that only listens to socket in current directory
pg_ctl start --options="-c listen_addresses= -c unix_socket_directories=$PGHOST"
# Setup database
psql -c "CREATE USER ibis WITH PASSWORD 'password' SUPERUSER;" -U postgres
psql -c "CREATE DATABASE ibis WITH OWNER ibis;" -U postgres