centos7备份postgres

vi /data/db_backup.sh

#!/bin/bash
cur_time=$(date '+%Y-%m-%d')
sevendays_time=$(date -d -3days '+%Y-%m-%d')
echo "Starting Backup PostgreSQL ..."
rm -rf "/home/postgres/db-backup/pgsql-backup.$sevendays_time.tar.gz"
/usr/pgsql-/bin/pg_dump -U postgres WildlifeMonitoring > "/home/postgres/db-backup/WildlifeMonitoring-$cur_time.bak"
tar zcvf "/home/postgres/db-backup/pgsql-backup.$cur_time.tar.gz" "/home/postgres/db-backup/WildlifeMonitoring-$cur_time.bak"
echo "Remove temp file ..."
rm -rf "/home/postgres/db-backup/WildlifeMonitoring-$cur_time.bak"
echo "Finish Backup ..."

chmod -R  /data

su postgres
crontab -e
* * * * * /data/db_backup.sh