Scripts/sxpsql-recreatedb
From Scalix Wiki
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