restorePostgres.sh

#!/bin/bash

if [[ "$1" == "" ]]; then
    echo "Dump file to restore not specified, please give it as parameter."
    exit 1
fi

echo "Stopping apache2"
sudo service apache2 stop

#echo "Stopping tomcat7"
#sudo service tomcat7 stop

echo "Restarting postgresql"
sudo service postgresql restart

echo "Dropping mydb database"
sudo -u postgres dropdb mydb

echo "Creating new mydb database"
sudo -u postgres createdb mydb

echo "Restoring backup dump"
#sudo -u postgres pg_restore --create --clean -v -d mydb $1
sudo -u postgres pg_restore -v -d mydb $1

#echo "Starting tomcat7"
#sudo service tomcat7 start

echo "Starting apache2"
sudo service apache2 start