# DB 정보설정
dbname=dbname
port=5432
username=postgresql
if [ "" != "$1" ]; then
	file_name=$1
else
	host_name=db.xxxx.com
	file_name=db_xxxx_backup.gz
fi

read -p "대상서버: " name

if [ -n "$name" ]; then
	host_name="$name"
fi

echo "================================"
echo "== 장고-데이터를 복원합니다.  =="
echo "== 서버       : $host_name"
echo "== 백업파일명 : $file_name"
echo "================================"

<<comment
PostgreSQL을 복원합니다.
comment

gunzip -c ${file_name} | psql --dbname={dbname} --host=${host_name} --port=${port} --username=${username}

if [ $? -eq 0 ]; then
  echo "================================"
  echo "== 서버명  - ${host_name}  =="
  echo "== 복원성공- ${file_name}  =="
  echo "================================"
else
  echo "================================"
  echo "Failure!"
  echo "================================"
fi