选择你安装的数据库目录位置选到bin文件夹,根据你要备份数据库,修改bat文件,主要修改bat文件的ip地址和端口号,还有备份的位置。
@echo off
d:
cd D:\Program Files\PostgreSQL\12\bin
set PGPASSWORD=postgres
set PRJDB1=acquisition
set PRJDB2=acquisition1
set PRJDB3=spider
set PRJDB4=spider18
set PRJDB5=spider19
set PRJDB6=spider21
set PRJDB7=spider22
set PRJDB8=atplatform31
set PRJDB9=at_uacp
set PRJDB10=envsys
set PRJDB11=uacp
set PRJDB12=uacp_sjzx
set PRJDB13=vgs_sjzx
pg_dump --host 10.18.166.199 --port 54321 --username "postgres" --format custom --blobs --verbose --file "D:\databace\%PRJDB1%-%date:~0,4%-%date:~5,2%-%date:~8,2%-%time:~0,2%-%time:~3,2%-%time:~6,2%.dump" acquisition
pg_dump