@echo off

CD \
C:

:: #################################  VARIABLES  #################################

SET idcliente=3102
SET cliente=QuerenciaPM

SET pghost=localhost
SET pgport=5432
SET pgdata=elotech
SET pguser=postgres
SET pgpassword=%postgres%

SET data=%DATE:~6,4%%DATE:~3,2%%DATE:~0,2%

SET pgdirbin="C:\Program Files\PostgreSQL\9.5\bin"

SET pgsecdir=D:\JR-Sistemas\Security\Prefeitura\QuerenciaPM





:: #################################  EXECUTION  #################################

%pgdirbin%\vacuumdb.exe -h %pghost% -p %pgport% -U %pguser% -d elotech -f -z -e -v > %pgsecdir%\%idcliente%_%data%_PE_%cliente%.vacuumdb 2>&1

timeout /t 10

exit /b 255