#!/bin/sh
# run-postresql -- start up postgresql postmaster

ROOT=/bio/biodb

POSTGRES_HOME=$ROOT/common/servers/postgresql/
PGDATA=$POSTGRES_HOME/data

FB_PGDATA=$ROOT/flybase/indices/pgsql
EUGENES_PGDATA=$ROOT/eugenes/indices/pgsql
DAPHNIA_PGDATA=$ROOT/daphnia/indices/pgsql
## used flybase mysql port 7301
PGPORT=7302

pglog=$ROOT/logs/pgsql.log

runconf=install.conf

PRG="$0"
# resolve symlinks -h
while [ -h "$PRG" ]; do
  ls=`ls -ld "$PRG"`
  link=`expr "$ls" : '.*-> \(.*\)$'`
  if expr "$link" : '.*/.*' > /dev/null; then
    PRG="$link"
  else
    PRG=`dirname "$PRG"`/"$link"
  fi
done
PRGDIR=`dirname "$PRG"`

## override (possibly) above settings
if [ -r "$PRGDIR"/$runconf ]; then
  . "$PRGDIR"/$runconf
fi
if [ -r "$PRGDIR"/${runconf}.local ]; then
  . "$PRGDIR"/${runconf}.local
fi

export POSTGRES_HOME

## only if desired ..
PATH=${POSTGRES_HOME}/bin:${PATH}
export PATH

MANPATH=${MANPATH}:${POSTGRES_HOME}/man
export MANPATH

PGLIB=${POSTGRES_HOME}/lib
## fixme for multiple OSes
LD_LIBRARY_PATH=${PGLIB} ; export LD_LIBRARY_PATH
DYLD_LIBRARY_PATH=${PGLIB} ; export DYLD_LIBRARY_PATH

### use PG initlocation for service-specific data sets
# initdb --no-locale -L $POSTGRES_HOME/share -D $PGDATA
# initlocation FB_PGDATA
# pg_ctl -o "-i -F -p $PGPORT" -D $PGDATA -l $ROOT/logs/pgsql.log start
# createuser -A -P fbwork  [FlyBase password]
# createdb -D FB_PGDATA gadfly3_chado gadfly3_dump_05_29apr03

# ----- Execute The Requested Command -----------------------------------------

if [ "$1" = "start" ] ; then
  shift
  ${POSTGRES_HOME}/bin/pg_ctl -o "-i -F -p $PGPORT" -D $PGDATA -l $pglog  start

elif [ "$1" = "stop" ] ; then
  shift
  ${POSTGRES_HOME}/bin/pg_ctl -D $PGDATA  stop
  
elif [ "$1" = "restart" ] ; then
  shift
  ${POSTGRES_HOME}/bin/pg_ctl -o "-i -F -p $PGPORT" -D $PGDATA restart

elif [ "$1" = "reload" ] ; then
  shift
  ${POSTGRES_HOME}/bin/pg_ctl  -D $PGDATA reload
  
elif [ "$1" = "status" ] ; then
  shift
  ${POSTGRES_HOME}/bin/pg_ctl  -D $PGDATA status
  
else
  echo "Usage: $0 ( commands ... )"
  echo "commands:"
  echo "  start             Start PostgreSQL server"
  echo "  stop              Stop PostgreSQL"
  echo "  restart           Re-Start PostgreSQL server"
  echo "  reload            Reload PostgreSQL configurations"
  echo "  status            report status of PostgreSQL server "
	echo "Using POSTGRES_HOME:  $POSTGRES_HOME"
	echo "Using PGPORT:         $PGPORT"
	echo "Logging to:           $pglog"
	echo
	
  exit 1

fi