我有一个简单的脚本,它使用rsync将Postgres数据库复制到备份位置,以便与Point In Time Recovery一起使用.该脚本每2小时通过postgres用户的cron作业运行.出于某种奇怪的原因,我可以看到进程列表中运行的三个rsync副本.任何想法为什么会这样?
这是cron条目:
# crontab -u postgres -l
PATH=/bin:/usr/bin:/usr/local/bin
0 */2 * * * /var/lib/pgsql/9.0/pitr_backup.sh
这是ps列表,它显示了两个rsync运行副本和一个睡眠副本:
# ps ax |grep rsync
9102 ? R 2:06 rsync -avW /var/lib/pgsql/9.0/data/ /var/lib/pgsql/9.0/backups/pitr_archives/20110629100001/ --exclude pg_xlog --exclude recovery.conf --exclude recovery.done --exclude pg_log
9103 ? S 0:00 rsync -avW /var/lib/pgsql/9.0/data/ /var/lib/pgsql/9.0/backups/pitr_archives/20110629100001/ --exclude pg_xlog --exclude recovery.conf --exclude recovery.done --exclude pg_log
9104 ? R 2:51 rsync -avW /var/lib/pgsql/9.0/data/ /var/lib/pgsql/9.0/backups/pitr_archives/20110629100001/ --exclude pg_xlog --exclude recovery.conf --exclude recovery.done --exclude pg_log
以下是似乎是问题原因的超级简单脚本:
#!/bin/sh
LOG="/var/log/pgsql-pitr-backup.log"
base_backup_dir="/var/lib/pgsql/9.0/backups"
wal_archive_dir="$base_backup_dir/wal_archives"
pitr_archive_dir="$base_backup_dir/pitr_archives"
timestamp=`date +%Y%m%d%H%M%S`
backup_dir="$pitr_archive_dir/$timestamp"
mkdir -p $backup_dir
echo `date` >> $LOG
/usr/bin/psql -U postgres -c "SELECT pg_start_backup('$backup_dir');"
rsync -avW /var/lib/pgsql/9.0/data/ $backup_dir/ --exclude pg_xlog --exclude recovery.conf --exclude recovery.done --exclude pg_log
/usr/bin/psql -U postgres -c "SELECT pg_stop_backup();"