写计划,每天下班前备份
[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