pgsql 异地备份脚本

#!/bin/bash
DUMP=/usr/pgsql-10/bin/pg_dumpall
OUT_DIR=/pgsqldump
DB_USER=postgres
DATE=`date +%F`
OTHER_HOST=10.10.10.114
OTHER_HOST_DIR=/108pgsqlbak/

   cd $OUT_DIR
   echo "`date +%H:%M:%S` dump start" >> /root/script/dump.log
#   pg_dump  -U $DB_USER -p 5432 ssta_sm > $DATE.sql
   pg_dumpall  -U $DB_USER -p 5432 > $DATE.sql
if [ $? -eq 0 ];then
   echo "`date +%H:%M:%S` dump success" >> /root/script/dump.log
   tar -zvcf $DATE.sql.tar.gz $DATE.sql > /dev/null 2>&1
   rm -f $DATE.sql
   echo "`date +%H:%M:%S` dump $DATE.sql.tar.gz success" >> /root/script/dump.log
else
   echo "`date +%H:%M:%S` dump $DATE.sql.tar.gz error" >> /root/script/dump.log
   exit
fi
   scp $DATE.sql.tar.gz root@$OTHER_HOST:$OTHER_HOST_DIR > /dev/null 2>&1
if [ $? -eq 0 ];then
   echo "`date +%H:%M:%S` scp $DATE.sql.tar.gz--------->$OTHER_HOST  $DATE.sql.tar.gz down " >> /root/script/dump.log
   echo "`date +%H:%M:%S` remove $DATE.sql.tar.gz start" >> /root/script/dump.log
   rm -f $DATE.sql.tar.gz
   echo "`date +%H:%M:%S` remove $DATE.sql.tar.gz down" >> /root/script/dump.log
else
   echo "`date +%H:%M:%S` scp $DATE.sql.tar.gz error " >> /root/script/dump.log
   exit
fi