/sbin/service JBOSS_SVC stop
/sbin/service SCM_SVC stop
/sbin/service nginx stop

# Main settings
cdb=/tmp
pgaddr=localhost

# Set PostgreSQL password for access to remote DB
PGPASSWORD=postgres
export PGPASSWORD

psql --host localhost --port 5432 --username postgres -t -c "ALTER DATABASE set RENAME TO set_old"
psql --host localhost --port 5432 --username postgres -t -c "ALTER DATABASE set_operday RENAME TO set_operday_old"
psql --host localhost --port 5432 --username postgres -t -c "ALTER DATABASE set_loyal RENAME TO set_loyal_old"

createdb -h $pgaddr -p 5432 -U postgres set
createdb -h $pgaddr -p 5432 -U postgres set_loyal
createdb -h $pgaddr -p 5432 -U postgres set_operday


pg_restore --host $pgaddr --port 5432 --username postgres --dbname=set --verbose < $cdb/set.backup 2> $cdb/R_set.log
pg_restore --host $pgaddr --port 5432 --username postgres --dbname=set_loyal --verbose < $cdb/set_loyal.backup 2> $cdb/R_set_loyal.log
pg_restore --host $pgaddr --port 5432 --username postgres --dbname=set_operday --verbose < $cdb/set_operday.backup 2> $cdb/R_set_operday.log