windows 脚本自动备份和恢复pg数据库

不用输入密码

::脚本的路径在 D:\Program Files\PostgreSQL\9.0
::filename: pgBackup.bat
cd ./bin
@set PGPASSWORD=88075998
pg_dump  -h localhost -U postgres -c tms >  ../tmsCopy.dump

 

 

::脚本的路径在 D:\Program Files\PostgreSQL\9.0
::filename: pgRecover.bat
cd ./bin
rem 恢复
@set PGPASSWORD=88075998
psql -h localhost -U postgres -d tms <  ../tmsCopy.dump