_PATH=$PATH

PATH=${PGHOME}/bin:$PATH
export PATH

LANG=C
export LANG

PGPORT=5433
export PGPORT

function _initdb()
{
    CONF=$1

    rm -rf $PGDATA
    mkdir $PGDATA
    initdb -D $PGDATA --no-locale -E utf-8 $_INITDB_OPTS

    if [ -f $CONF ]; then
	echo "Adding $CONF to postgresql.conf"
	cat $CONF >> ${PGDATA}/postgresql.conf
    fi
}

function _pgctl_start()
{
    pg_ctl -D ${PGDATA} -w start
}

function _pgctl_stop()
{
    pg_ctl -D ${PGDATA} -w stop
}

function _install_pg_stat_statements()
{
    DBNAME=$1

    if [ -d $PGHOME/share/contrib ]; then
	psql -f $PGHOME/share/contrib/pg_stat_statements.sql $DBNAME
	if [ $? -ne 0 ]; then
	    echo "Failed to install pg_stat_statements."
	    exit 1
	fi
    else
	psql -c 'create extension pg_stat_statements' $DBNAME
	if [ $? -ne 0 ]; then
	    echo "Failed to install pg_stat_statements."
	    exit 1
	fi
    fi
}

function _install_pgstattuple()
{
    DBNAME=$1

    if [ -d $PGHOME/share/contrib ]; then
	psql -f $PGHOME/share/contrib/pgstattuple.sql $DBNAME
	if [ $? -ne 0 ]; then
	    echo "Failed to install pgstattuple."
	    exit 1
	fi
    else
	psql -c 'create extension pgstattuple' $DBNAME
	if [ $? -ne 0 ]; then
	    echo "Failed to install pgstattuple."
	    exit 1
	fi
    fi
}

function _get_version()
{
    _MAJORVERSION=`pg_config --version | perl -e 's/.* (\d+\.\d+).*/\1/;' -p`
    export _MAJORVERSION

    _MAJOR_STR=`echo $_MAJORVERSION | sed 's/\.//'`
    export _MAJOR_STR
}

function load_file()
{
    DBNAME=$1;
    FILENAME=$2;

    if [ -f $FILENAME ]; then
	echo "Loading ${FILENAME} ..."
	psql -f $FILENAME $DBNAME
	if [ $? -ne 0 ]; then
	    echo "Failed to run $FILENAME on $DBNAME.".
	    exit 1
	fi
    else
	echo "ERROR: $FILENAME not found."
	exit 1
    fi
}