xxxxxxxxxx
#!/bin/bash
CURRENT_DIR=$(cd $(dirname "$0");pwd)
MYPATH=$CURRENT_DIR/../..
function delFile(){
if [ -e "/tmp/.s.PGSQL.5432" ];then
rm /tmp/.s.PGSQL.5432
fi
if [ -e "/tmp/.s.PGSQL.5432.lock" ];then
rm /tmp/.s.PGSQL.5432.lock
fi
}
function restore(){
$MYPATH/pgsql/bin/dropdb -U xsadmin xs_mng
$MYPATHHOME/pgsql/bin/createdb xs_mng -U xsadmin
$MYPATH_HOME/pgsql/bin/psql -d xs_mng -U xsadmin < $MYPATH/pgsql/bin/backup.sql
}
restore