cd `dirname $0`
cd ..


source /dportal/box/env.sh
export NEWPGDATABASE=dload

if [ ! -z "$1" ] ; then

export NEWPGDATABASE=$1

fi

echo " swapping $NEWPGDATABASE database with $PGDATABASE database "


sudo /etc/init.d/dportal stop

sudo -u postgres bash -c "dropdb dtmp"

sudo -u postgres bash -c "psql -c \"select pg_terminate_backend(pid) from pg_stat_activity where datname='$NEWPGDATABASE';\" postgres"
sudo -u postgres bash -c "psql -c \"select pg_terminate_backend(pid) from pg_stat_activity where datname='$PGDATABASE';\" postgres"

sleep 5

sudo -u postgres bash -c "psql -c \"ALTER DATABASE $PGDATABASE     RENAME TO dtmp;\" postgres"
sudo -u postgres bash -c "psql -c \"ALTER DATABASE $NEWPGDATABASE  RENAME TO $PGDATABASE;\" postgres"
sudo -u postgres bash -c "psql -c \"ALTER DATABASE dtmp            RENAME TO $NEWPGDATABASE;\" postgres"

source /dportal/box/env.sh

sudo /etc/init.d/dportal start