- @ECHO OFF
- @ECHO ============================
- @ECHO PostgreSQL Backup Command
- @ECHO ============================
- @set DirName=%date:~0,7%
- @set FileName=%date:~0,10%.backup
- @if %date:~8,2% == 01 (md D:\\Backup\\”%DirName%”)
- @if not exist D:\\Backup\\”%DirName%” (md D:\\Backup\\”%DirName%”)
- “C:\\Program Files\\PostgreSQL\\9.3\\bin\\pg_dump.exe” -i -h localhost-p 5432 -U sec -b -c -C -d -D -Fc -v -f D:\\Backup\\%FileName% techpro_db
- if exist D:\\Backup\\%FileName% (“C:\\Program Files\\WinRAR\\WinRAR.exe” a -df D:\\Backup\\%FileName%.rar D:\\Backup\\%FileName%)
- @ECHO ON
- #该片段来自于http://www.codesnippet.cn/detail/060120148431.html
来源: http://www.codesnippet.cn/detail/060120148431.html