postgresql备份的sh

fighter1945

 
 
#!/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下面每天备份
要是有问题，一般是权限问题