@echo off
set HOST=<MI SERVIDOR>
set PORT=5432
set DATABASE= <MI BASE DE DATOS>
set USERDB= <MI USUARO>
set PGPASSWORD= <MI PASSWORD>
set BAK_FILE=<NOMBRE DEL ARCHIVO BACKUP>
set anno=%date:~6,4%
set mes=%date:~3,2%
set dia=%date:~0,2%
set hora=%time:~0,2%
set minuto=%time:~3,2%
set segundo=%time:~6,2%
pg_dump ^
--file bak_%BAK_FILE%_%anno%%mes%%dia%.sql ^
--host %HOST% ^
--port %PORT% ^
--username %USERDB% ^
--verbose ^
--format=plain ^
--create ^
--clean ^
--section=pre-data ^
--section=data ^
--section=post-data ^
%DATABASE%
set HOST=
set PORT=
set DATABASE=
set USERDB=
set PGPASSWORD=
set BAK_FILE=
set anno=
set mes=
set dia=
set hora=
set minuto=
set segundo=
Crear cuenta
