bkpPostgresEsus.bat

 
C:\e-SUS-AB\e-SUS-AB PEC\PostgreSQL\9.3\bin>pg_dump.exe -i -h localhost -p 5433
-U postgres -F c -b -v -f C:\Users\Public\bkp\bkp.backup esus

    @echo off
   for /f "tokens=1-4 delims=/ " %%i in ("%date%") do (
     set dow=%%i
     set month=%%j
     set day=%%k
     set year=%%l
   )
   set datestr=%month%_%day%_%year%
   echo datestr is %datestr%
    
   set BACKUP_FILE=C:\Users\Public\bkp\esus_%datestr%.backup
   echo backup file name is %BACKUP_FILE%
   SET PGPASSWORD=esus
   echo on
   pg_dump.exe -i -h localhost -p 5433 -U postgres -F c -b -v -f %BACKUP_FILE% esus