@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
SET pgdirbkp=D:\Elotech\Backup\PostgreSQL

SET pebackup=%pgdirbkp%\%idcliente%_%data%_PE_%cliente%.backup
SET pgbackup=%pgdirbkp%\%idcliente%_%data%_PG_%cliente%.backup

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

%pgdirbin%\pg_dump.exe -h %pghost% -p %pgport% -U %pguser% -F c -b -v -f "%pebackup%" -N eloarquivo %pgdata%
%pgdirbin%\pg_dump.exe -h %pghost% -p %pgport% -U %pguser% -F c -b -v -f "%pgbackup%" %pgdata%
timeout /t 10

copy /y %pgdirbkp%\%idcliente%_%data%_PE_%cliente%.backup %pgsecdir%\%idcliente%_%data%_PE_%cliente%.backup
copy /y %pgdirbkp%\%idcliente%_%data%_PG_%cliente%.backup %pgsecdir%\%idcliente%_%data%_PG_%cliente%.backup
timeout /t 10

forfiles -p %pgdirbkp% -s -m *.* -d -7 -c "cmd /c del /f /q @path"
forfiles -p %pgsecdir% -s -m *.backup -d -14 -c "cmd /c del /f /q @path"
timeout /t 10

exit /b 255