windows - Postgresql备份脚本如何写日志

Question

我有这个用于 PostgreSQL 数据库备份的脚本。该脚本会备份除数组中传递的数据库之外的所有数据库。一切都很完美。但我不知道如何将脚本的结果输出并保存到日志文件中。请告诉我。先感谢您！

set PGPASSWORD=Password
set BACKUPPATH=Q:\PostgresBackup
set DATETIME=%DATE:~6,4%-%DATE:~3,2%-%DATE:~0,2% %TIME:~0,2%-%TIME:~3,2%-%TIME:~6,2%
set LOGFILE=%DATETIME%.log
set LOGPATH=E:\backup1c\log\%LOGFILE%
set PSQL=Z:\base1c\10\bin\psql.exe
set PGDUMP=Z:\base1c\10\bin\pg_dump.exe
:: dump all bases not in (test,postgres, temp*)
for /F  %%i in ( '%PSQL% -t -h 127.0.0.1 -U postgres  -c "select  datname FROM pg_database WHERE datname NOT LIKE ALL (ARRAY[ 'test','postgres','temp%%']);" ')  do ( 
    echo %%i
    for /f "tokens=1-7 delims=/-:., " %%a in ( "%DATE: =0% %TIME: =0%" ) do ( 
    %PGDUMP%    -U postgres -Fc -b -v -f %BACKUPPATH%\%%i-%%c-%%b-%%a_%%d_%%e.backup %%i 2>%LOGPATH%
                                        )
    ) 

标签： windowspostgresqlbatch-fileloggingdatabase-backups