postgres数据库备份bat（免输密码）

`
@ECHO OFF
@setlocal enableextensions
@cd /d "%~dp0"

set PGPASSWORD=postgres
SET PGPATH="C:\Program Files\PostgreSQL\9.6\bin"
SET SVPATH=D:\99BACKUP_POSTGRES
SET PRJDB=jxgl2021
set d=%DATE:_0,4%%DATE:5,2%%DATE:_8,2%%TIME:0,2%%TIME:_3,2%%TIME:6,2%

SET DBDUMP=%PRJDB%_%d%.sql
@ECHO OFF
%PGPATH%pg_dump -h localhost -U postgres -d %PRJDB% -f %SVPATH%%DBDUMP%

echo Backup Taken Complete %SVPATH%%DBDUMP%

@REM 删除5天前的文件
@REM forfiles /p %SVPATH% /d /m *.bak -5 /c "cmd /c echo deleting @file ... && del /f @path"
`