postgresql备份的sh
#!/bin/sh# Get FileName from 'Date' commandDATAFILE=`date '+testdb2009_back%y%m%d.gz'`DATADIR=/usr/local/pgsql/backup_testdb2009echo "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]