pgBackup

@echo off

CD \
C:

SET idcliente=3102
SET cliente=QuerenciaPM

SET version=9.6
SET pghost=localhost
SET pgport=5432
SET pgdata=elotech
SET pguser=postgres
SET pgpassword=jrb@nc0Post

SET datatime=%DATE:~6,4%%DATE:~3,2%%DATE:~0,2%-%TIME:~0,2%%TIME:~3,2%
SET data=%DATE:~6,4%%DATE:~3,2%%DATE:~0,2%
SET pgdirbkp=D:\Security\Backup\Local
SET pebackup=%pgdirbkp%\%idcliente%_%data%_PE_%cliente%.backup
SET pgbackup=%pgdirbkp%\%idcliente%_%data%_PG_%cliente%.backup
SET pgdircloud=D:\Security\Backup\Cloud\"Dropbox (jrsecurity)"\JRSecurity\%cliente%
SET pgdirbin="C:\Program Files\PostgreSQL\%version%\bin"


%pgdirbin%\pg_dump.exe -h %pghost% -p %pgport% -U %pguser% -F c -b -v -f "%pebackup%" -N eloarquivo %pgdata%
copy /y %pgdirbkp%\%idcliente%_%data%_PE_%cliente%.backup %pgdircloud%\%idcliente%_%data%_PE_%cliente%.backup

%pgdirbin%\pg_dump.exe -h %pghost% -p %pgport% -U %pguser% -F c -b -v -f "%pgbackup%" %pgdata%
copy /y %pgdirbkp%\%idcliente%_%data%_PG_%cliente%.backup %pgdircloud%\%idcliente%_%data%_PG_%cliente%.backup

timeout /t 10
exit /b 255



@echo off

cd \
C:

:: ############################################################################################
:: ##                                      PRÉ-EXECUÇÃO                                      ##
:: ############################################################################################

SET idcliente=3025
SET cliente=PalotinaPM

SET pghost=localhost
SET pgport=5432
SET pgdata=elotech
SET pguser=postgres
SET pgpassword=jrb@nc0Post

SET datetime=%DATE:~6,4%%DATE:~3,2%%DATE:~0,2%_%TIME:~0,2%%TIME:~3,2%
SET data=%DATE:~6,4%%DATE:~3,2%%DATE:~0,2%
SET pgdirbkp=Z:\Security\Backup\Local
SET pebackup=%pgdirbkp%\%idcliente%_%data%_PE_%cliente%.backup
SET pgbackup=%pgdirbkp%\%idcliente%_%data%_PG_%cliente%.backup
SET pgdircloud=Z:\Security\Backup\Cloud\"Dropbox (jrsecurity)"\JRSecurity\PalotinaPM
SET pgdirbin="C:\Program Files\PostgreSQL\9.5\bin"

:: ############################################################################################
:: ##                                         EXECUÇÃO                                       ##
:: ############################################################################################

%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%

copy /y %pgdirbkp%\%idcliente%_%data%_PE_%cliente%.backup %pgdircloud%\%idcliente%_%data%_PE_%cliente%.backup
copy /y %pgdirbkp%\%idcliente%_%data%_PG_%cliente%.backup %pgdircloud%\%idcliente%_%data%_PG_%cliente%.backup

timeout /t 10
exit /b 255