- 备份:
@ECHO OFF
@setlocal enableextensions
@cd /d "%~dp0"
::PG安装路径
SET PGPATH=C:\"Program Files"\PostgreSQL\13\bin\pg_dump
::用户名
SET DBUSR=postgres
::密码
set PGPASSWORD=postgres
::角色
SET DBROLE=postgres
FOR /F "TOKENS=1,2,3 DELIMS=/ " %%i IN ('DATE /T') DO SET d=%%i-%%j-%%k
FOR /F "TOKENS=1,2,3 DELIMS=: " %%i IN ('TIME /T') DO SET t=%%i%%j%%k
::备份文件保存位置
SET SVPATH=D:\SoftWareData\03.PostgreSQL\01.Backup\%d%_%t%
::
if not exist %SVPATH% md %SVPATH%
echo %SVPATH%
SET DBDUMPBusiness=JJZHYJDB_Business
SET DBDUMPGIS=JJZHYJDB_Gis
@ECHO OFF
echo %SVPATH%\%DBDUMPBusiness%.backup
echo %SVPATH%\%DBDUMPGIS%.backup
%PGPATH% -h localhost -p 5432 -U %DBUSR% --role %DBROLE% --password=%PGPASSWORD% -w -F c -b -v -f %SVPATH%\%DBDUMPBusiness%.backup %DBDUMPBusiness%
%PGPATH% -h localhost -p 5432 -U %DBUSR% --role %DBROLE% --password=%PGPASSWORD% -w -F c -b -v -f %SVPATH%\%DBDUMPGIS%.backup %DBDUMPGIS%
echo Backup Taken Complete %SVPATH%\%DBDUMPBusiness%.backup
echo Backup Taken Complete %SVPATH%\%DBDUMPBusiness%.backup
pause
上面是.bat文件的编写脚本
网上大多数没有"--password=%PGPASSWORD%",会出现数据库连接不成功。
QQ群(GIS开发交流、数据共享、软件使用):993836992