@echo off
call setenv.bat
set PGBIN=%PG_HOME%\bin\pg_dump.exe
set PGPASSWORD=%PG_PASSWORD%
set DB_NAME=postgres
set BACKUP_DIR="backup"
for /f "delims=" %%i in ('"%JAVA_HOME%\bin\java.exe" -jar upgrade.jar logname sql dump_') do set dumpname=%%i
if not exist "%BACKUP_DIR%" (
  mkdir "%BACKUP_DIR%"
)
"%PGBIN%" -c -O -x -p %PG_PORT% -U %PG_USER% -n public -f "%BACKUP_DIR%\%dumpname%" %DB_NAME%

"C:\Program Files\7-zip\7z.exe" a -tzip -ssw -mx1 "%BACKUP_DIR%\%dumpname%".zip "%BACKUP_DIR%\%dumpname%"

del "%BACKUP_DIR%\%dumpname%"

call setenv.bat