Advertisement
Guest User

Untitled

a guest
Jul 30th, 2020
21
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.87 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\"
  8.  
  9. echo %daynow%
  10.  
  11. if %daynow% == Вс (
  12. @set backup_mode = FULL
  13. )
  14. if NOT %daynow% == Вс (
  15. @set backup_mode = DELTA
  16. )
  17.  
  18. echo "Копирование %backupmode%" >> D:\backup\backup.log 2>&1
  19. %PGPATH% backup -B %BackPATH% -d "STATEHRM_atp" --instance 1c -b %backupmode% -U postgres --progress --stream --retention-window=7 --retention-redundancy=2 -j 6
  20. echo "Копирование завершено успешно %backupmode% %date%" >> D:\backup\backup.log 2>&1
  21. exit
  22.  
  23.  
  24.  
  25. :initinstance
  26. %pgpath% init -b d:\backup\pg_probackup\
  27. %pgpath% add-instance -b d:\backup\pg_probackup\ --instance 1c -d e:\pgsql\data\
  28. exit
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement