windows自动备份bat

自己的第一篇bat,六月的时候写的,今天突然想写篇博客,就把它拿出来了;

V - Distpicker

@echo off
set pgsql_path=C:\workwork\PostgreSQL\10\bin\
set database=postgres
set server=localhost
set post=******
set username=postgres
set d=%date:~,10%
set d=%d:-=%
set d=%d:/=%
set t=%time:~,8%
set t=%t::=%
set t=%t: =0%
set back_path=C:\Backup
if not exist %back_path% md %back_path%
set file_string=%back_path%\%username%_%d%_%t%
set file=%file_string%.sql
%pgsql_path%pg_dump.exe -h%server% -p%post% -U%username% %database% >%file%
rem pause  
rem 如果这段代码运行出问题就把上面的rem删掉
rem  到环境变量里配置PGPASSWORD