PG数据库定时逻辑备份脚本(适用windows)

ZhangQi

@echo off
chcp 65001 >nul
setlocal

:: ====================== 配置项 ======================
set "PGPASSWORD=zlhis" :: 改成postgres密码
set "PGHOME=D:\Program Files\PostgreSQL\11\bin"    :: 改成你实际的 pg 安装路径
set "BACKUP_DIR=D:\backup" :: 改成你实际的 pg 备份路径
for /f "tokens=1-3 delims=-/. " %%a in ('powershell "Get-Date -Format 'yyyy-MM-dd'"') do set "CUR_TIME=%%a-%%b-%%c"

:: ==================================================

echo Starting Backup PostgreSQL ...
"%PGHOME%\pg_dumpall" -h 127.0.0.1 -U postgres -c > "%BACKUP_DIR%\pgsql-backup.%CUR_TIME%.sql"
echo Finish Backup !

:: 删除5天前的备份
forfiles /p "%BACKUP_DIR%" /m "pgsql-*" /d -5 /c "cmd /c del /f @path"

echo delete over