Scripts/sxpsql-recreatedb

sxpsql-recreatedb

#!/bin/sh
#
# Drops and remakes the scalix DB.
#
# Usage: sxpsql-recreatedb
#

# Pass "" to prevent implicit passing of $*
. /opt/scalix-postgres/bin/common-helpers.sh ""

/etc/init.d/scalix-tomcat status | grep 'is running' >/dev/null 2>/dev/null
if [ $? = "0" ]; then
    TOMCAT_RUNNING=1
else
    TOMCAT_RUNNING=0
fi

if [ $TOMCAT_RUNNING -eq 1 ]; then
    /etc/init.d/scalix-tomcat stop
fi

/etc/init.d/scalix-postgres status | grep 'is running' >/dev/null 2>/dev/null
if [ $? = "0" ]; then
    POSTGRES_RUNNING=1
else
    POSTGRES_RUNNING=0
fi

if [ $POSTGRES_RUNNING -ne 1 ]; then
    /etc/init.d/scalix-postgres start
fi

su - -c "$PGENGINE/dropdb -h $PSQL_DIR -p $PSQL_PORT scalix" postgres || exit $?
su - -c "$PGENGINE/createdb -h $PSQL_DIR -p $PSQL_PORT -E UNICODE scalix" postgres || exit $?

if [ $TOMCAT_RUNNING -eq 1 ]; then
    /etc/init.d/scalix-tomcat start
fi