postgresql备份的sh
#!/bin/sh# Get FileName from 'Date' command
DATAFILE=`date '+testdb2009_back%y%m%d.gz'`
DATADIR=/usr/local/pgsql/backup_testdb2009
echo "Backup is beginning."
/usr/local/pgsql/bin/pg_dump testdb2009 | /bin/gzip > "$DATADIR/$DATAFILE"
echo "Backup is done."
稍微修改下
su -l postgres -c "/usr/local/pgsql/bin/pg_dump testdb2009 | /bin/gzip > '$DATADIR/$DATAFILE' "
放到/etc/cron.daily下面每天备份
要是有问题，一般是权限问题
页:
[1]