Advertisement
Guest User

Untitled

a guest
Jul 30th, 2020
24
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.32 KB | None | 0 0
  1. @echo off
  2. chcp 1251
  3.  
  4. REM set T=%DATE:~0,2%%DATE:~3,2%%DATE:~6,4%%TIME:~0,2%%TIME:~3,2%%TIME:~6,2%
  5. @set daynow=%DATE:~-0,2%
  6. @set PGPATH="C:\Program Files\pg_probackup\2.4.1\PostgreSQL10\pg_probackup.exe"
  7. @set BackPATH="D:\backup\pg_probackup\backups\1c"
  8.  
  9. echo %daynow%
  10.  
  11. if %daynow% == Вс ( GOTO :fullbackup )
  12. if NOT %daynow% == Вс ( GOTO :deltabackup )
  13.  
  14.  
  15. :fullbackup
  16. REM Полный_бекап_режим_FULL
  17. echo "Копирование FULL" >> D:\backup\backup.log 2>&1
  18. %PGPATH% backup -B D:\backup\pg_probackup\ -d "STATEHRM_atp" --instance 1c -b FULL -U postgres --progress --stream -j 6
  19. %PGPATH% delete -B D:\backup\pg_probackup\ --instance 1c --retention-window=7 --retention-redundancy=2
  20. echo "Копирование завершено успешно %date%" >> D:\backup\backup.log 2>&1
  21. exit
  22.  
  23. :deltabackup
  24. REM Инкрементный_бекап_режим_DELTA
  25. echo "Копирование DELTA" >> D:\backup\backup.log 2>&1
  26. %PGPATH% backup -B D:\backup\pg_probackup\ -d "STATEHRM_atp" --instance 1c -b DELTA -U postgres --progress --stream -j 6
  27. echo "Копирование завершено успешно %date%" >> D:\backup\backup.log 2>&1
  28. exit
  29.  
  30. :initinstance
  31. %pgpath% init -b d:\backup\pg_probackup\
  32. %pgpath% add-instance -b d:\backup\pg_probackup\ --instance 1c -d e:\pgsql\data\
  33. exit
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement