Postgresql之pg_dumpall生产环境自动化备份案例

• Postgresql之pg_dumpall生产环境自动化备份案例

(1) 编写shell脚本

vi /backup/scripts/pg_dumpall_all_backup.sh

#!/bin/bash
su - postgresql -c "pg_dumpall -h 10.10.10.199 -U postgres -p 5432 >/backup/crmdb-bak/all_databases-`date +%F-%s`.sql"
sleep 10
find /backup/crmdb-bak/*.sql -mtime +7 -exec rm {} \;

• ## 授权

chmod 755 /backup/scripts/pg_dumpall_all_backup.sh

(2) 配置自动计划任务
 

su - root
crontab -e
* 22 * * * /backup/scripts/pg_dumpall_all_backup.sh