Difference between revisions of "Instrucoes:Passo a passo:Diversos:Backup"
From MiniPCP Wiki
(Criou página com ' @echo off set day=%date:~0,2% set month=%date:~3,2% set year=%date:~6,4% set hour=%time:~0,2% set minute=%time:~3,2% set datestr=%year%_%month%_%day%_%hour%_%minute% echo dat...') |
|||
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| + | __NOTITLE__ | ||
| + | =Backup= | ||
| + | |||
| + | Para programar o backup automático em servidores Windows, crie um arquivo .bat com o script abaixo e crie uma tarefa no agendador de tarefas. | ||
| + | |||
| + | <pre> | ||
@echo off | @echo off | ||
set day=%date:~0,2% | set day=%date:~0,2% | ||
| Line 8: | Line 14: | ||
set datestr=%year%_%month%_%day%_%hour%_%minute% | set datestr=%year%_%month%_%day%_%hour%_%minute% | ||
echo datestr is %datestr% | echo datestr is %datestr% | ||
| − | set BACKUP_FILE= | + | set BACKUP_FILE=\caminho\para\backup\minipcp_%datestr%.dump |
echo O mome do arquivo de backup é %BACKUP_FILE% | echo O mome do arquivo de backup é %BACKUP_FILE% | ||
| − | SET PGPASSWORD= | + | SET PGPASSWORD=<Senha> |
echo on | echo on | ||
"C:\Program Files\PostgreSQL\9.6\bin\pg_dump.exe" -h localhost -p 5432 -U postgres -v -f %BACKUP_FILE% minipcp | "C:\Program Files\PostgreSQL\9.6\bin\pg_dump.exe" -h localhost -p 5432 -U postgres -v -f %BACKUP_FILE% minipcp | ||
| + | </pre> | ||
Latest revision as of 16:07, 5 July 2017
Backup
Para programar o backup automático em servidores Windows, crie um arquivo .bat com o script abaixo e crie uma tarefa no agendador de tarefas.
@echo off set day=%date:~0,2% set month=%date:~3,2% set year=%date:~6,4% set hour=%time:~0,2% set minute=%time:~3,2% set datestr=%year%_%month%_%day%_%hour%_%minute% echo datestr is %datestr% set BACKUP_FILE=\caminho\para\backup\minipcp_%datestr%.dump echo O mome do arquivo de backup é %BACKUP_FILE% SET PGPASSWORD=<Senha> echo on "C:\Program Files\PostgreSQL\9.6\bin\pg_dump.exe" -h localhost -p 5432 -U postgres -v -f %BACKUP_FILE% minipcp
