#
#
# build a mirror db in a remote server

bk_from=newark
bk_to=mtsv5
db_from=tm10
db_to=tm10bk_newark
set_triggers=tm_set_triggers

error()
{
	echo "ERROR: " $* >&2
	$set_triggers $db_from
	exit 1
}

cd /home/ctu
dat=$(date "+%m%d%y")


# don't dump db trigger
$set_triggers -r $db_from

# dump db
db_dump=${db_from}-${dat}.out
echo "dump db $db_from to $db_dump ..."
pg_dump $db_from > $db_dump

[ "$?" != "0" ] && error "pg_dump failed ..."


## copy  db to bk server
scp $db_dump $bk_to:

## rebuild remote backup db
ssh $bk_to dropdb $db_to
ssh $bk_to createdb -E UNICODE $db_to
ssh $bk_to psql -f $db_dump $db_to


# put back triggers
$set_triggers $db_from




