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...') |
|||
| Line 1: | Line 1: | ||
| + | __NOTITLE__ | ||
| + | =Diversos= | ||
| + | |||
| + | <pre> | ||
@echo off | @echo off | ||
set day=%date:~0,2% | set day=%date:~0,2% | ||
| Line 13: | Line 17: | ||
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> | ||
Revision as of 16:03, 5 July 2017
Diversos
@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=D:\minipcp_backup\minipcp_%datestr%.dump echo O mome do arquivo de backup é %BACKUP_FILE% SET PGPASSWORD=MiniPCP9095949 echo on "C:\Program Files\PostgreSQL\9.6\bin\pg_dump.exe" -h localhost -p 5432 -U postgres -v -f %BACKUP_FILE% minipcp
