Shell实现bash环境和 Postgres环境切换 case

#/bin/bash!
cd /opt/db
Yestday=$(date -d -1day +"%Y%m%d")
#Db_name=swiftlive_prod_$(date -d"yesterday" +"%F_22").dmp
#Db_name=swiftlive_prod_$(date -d"yesterday" +"%y-%m-%d_00").dmp
#Db_name=swiftlive_prod_$(date  +"%F_00").dmp
Db_name=swiftlive_prod_$(date  +"%y-%m-%d_00").dmp
Url=http://edge.conversant.swiftserve.com/DataBackup/databackup/postgresql/$Yestday/$Db_name
cd /opt/db
echo $Url
wget $Url


psql  << EOF
    drop database swiftlive_backup ;
    CREATE database swiftlive_backup with ENCODING='UTF8';
EOF


psql swiftlive_backup < /opt/db/$Db_name