Instrucoes:Passo a passo:Diversos:Backup

Backup

@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