postgresql定时备份

写计划，每天下班前备份

 

[root@izbp1fkjsjbc8a9uhtsg2cz ~]# crontab -e
00 18 * * * /var/lib/pgsql/9.6/backup.sh

 

写执行脚本

 

[root@iz~]# su postgres
bash-4.2$ pwd
                  /var/lib/pgsql/9.6
bash-4.2$ vim backup.sh 
                 #!/bin/bash
                 su - postgres -c "pg_dump -h localhost -U postgres yes > /var/lib/pgsql/9.6/backups/yes-`date '+%y-%m-%d'`.sql"
bash-4.2$ ls -l
                 -rwxr-xr-x  1 postgres postgres      124 Jan  8 11:44 backup.sh