Script de inicialização do PostgreSQL

#!/bin/bash

prefix="/usr/local/pgsql"

PGDATA="$prefix/data"

# PGUSER
PGUSER="postgres"

# log file
PGLOG="$prefix/data/logfile"

set -e

DAEMON="$prefix/bin/pg_ctl"

test -f $DAEMON || exit 0

up() {
      su $PGUSER -c "$DAEMON -D '$PGDATA' -o -i -l $PGLOG start"
}

down() {
      su $PGUSER -c "$DAEMON stop -D '$PGDATA' -s -m fast"
}

case $1 in
      start)
              echo -n "Iniciano PostgreSQL: "
              up
      ;;
      stop)
              echo -n "Parando PostgreSQL: "
              down
      ;;
      restart)
              echo -n "Reiniciando PostgreSQL: "
              down
              up
#               su $PGUSER -c "$DAEMON restart -D '$PGDATA' -l $PGLOG -s -m fast"
      ;;
      status)
              su $PGUSER -c "$DAEMON status -D '$PGDATA'"
      ;;
      *)
              echo "Modos de uso: postgresql {start|stop|restart|status}" 1>&2
              exit 1
      ;;
esac

exit 0

Eu não utilizei o restart do pg_ctl pois ele deixava de utilizar o logfile para armazenar as mensagens.