#!/bin/sh
# ----------------------------------------------------------------
#   FILE
# 	vacuum
#
#   DESCRIPTION
#	This program runs the monitor with the "-c" option to vacuum
#	the requested database.
#
#	We expect that this script will be run via cron nightly.  This
#	replaces vacuumd and vcontrol in earlier releases of postgres.
#
#   IDENTIFICATION
#     /usr/local/devel/postgres-v4r2/src/bin/vacuum/RCS/vacuum.sh,v 1.5 1994/03/20 03:17:53 aoki Exp
# ----------------------------------------------------------------

# ----------------
#       Set paths from environment or default values.
#       The _fUnKy_..._sTuFf_ gets set when the script is installed
#       from the default value for this build.
#	Currently the only thing we look for from the environment is
#	PGDATA, PGHOST, and PGPORT
# ----------------
[ -z "$PGPORT" ] && PGPORT=4321
[ -z "$PGHOST" ] && PGHOST=localhost
BINDIR=/usr/local/postgres/bin
PATH=$BINDIR:$PATH

CMDNAME=`basename $0`

if [ -z "$USER" ]; then
    if [ -z "$LOGNAME" ]; then
	if [ -z "`whoami`" ]; then
	    echo "$CMDNAME: cannot determine user name"
	    exit 1
	fi
    else
	USER=$LOGNAME
	export USER
    fi
fi

dbname=$USER

while test -n "$1"
do
    case $1 in
	-a) AUTHSYS=$2; shift;;
        -h) PGHOST=$2; shift;;
        -p) PGPORT=$2; shift;;
         *) dbname=$1;;
    esac
    shift;
done

AUTHOPT="-a $AUTHSYS"
[ -z "$AUTHSYS" ] && AUTHOPT=""

monitor -TN $AUTHOPT -h $PGHOST -p $PGPORT -c "vacuum" $dbname || {
    echo "$CMDNAME: database vacuum failed on $dbname."
    exit 1
}

exit 0