Export PostgreSQL CMD

@echo off
@mode CON: COLS=170 LINES=65
@color 0A

echo #####################################################
echo # EXPORTA UNA COPIA COMPLETA DE LA BASE DE DATOS    #
echo #####################################################

echo #
echo # Definimos las variables

for /f "tokens=1-4 delims=/ " %%i in ("%date%") do (
     set dow=%%i
     set month=%%j
     set day=%%k
     set year=%%l
)

SET datestr=%date:~-4,4%_%date:~-7,2%_%date:~0,2%
SET BACKUP_FILE="C:\Gestion\BackupBD\ProduccionOpenERP_%datestr%.backup"

SET PGHOST=127.0.0.1
SET PGPORT=5433
SET PGUSER=openerp
SET PGPASSWORD=openerp
SET PGDBNAME=produccion

ECHO La ruta del fichero de backup es %BACKUP_FILE%

@echo on
"C:\Gestion\PostgreSQL\bin\pg_dump" -i -h %PGHOST% -p %PGPORT% -U %PGUSER% -F c -b -v -f %BACKUP_FILE% %PGDBNAME%
@echo off

exit