PostgreSQL定时备份数据库脚本

选择你安装的数据库目录位置选到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 --host 10.18.166.199 --port 54321 --username "postgres" --format custom --blobs --verbose --file "D:\databace\%PRJDB2%-%date:~0,4%-%date:~5,2%-%date:~8,2%-%time:~0,2%-%time:~3,2%-%time:~6,2%.dump" acquisition1
pg_dump --host 10.18.166.199 --port 54321 --username "postgres" --format custom --blobs --verbose --file "D:\databace\%PRJDB3%-%date:~0,4%-%date:~5,2%-%date:~8,2%-%time:~0,2%-%time:~3,2%-%time:~6,2%.dump" spider
pg_dump --host 10.18.166.199 --port 54321 --username "postgres" --format custom --blobs --verbose --file "D:\databace\%PRJDB4%-%date:~0,4%-%date:~5,2%-%date:~8,2%-%time:~0,2%-%time:~3,2%-%time:~6,2%.dump" spider18
pg_dump --host 10.18.166.199 --port 54321 --username "postgres" --format custom --blobs --verbose --file "D:\databace\%PRJDB5%-%date:~0,4%-%date:~5,2%-%date:~8,2%-%time:~0,2%-%time:~3,2%-%time:~6,2%.dump" spider19
pg_dump --host 10.18.166.199 --port 54321 --username "postgres" --format custom --blobs --verbose --file "D:\databace\%PRJDB6%-%date:~0,4%-%date:~5,2%-%date:~8,2%-%time:~0,2%-%time:~3,2%-%time:~6,2%.dump" spider21
pg_dump --host 10.18.166.199 --port 54321 --username "postgres" --format custom --blobs --verbose --file "D:\databace\%PRJDB7%-%date:~0,4%-%date:~5,2%-%date:~8,2%-%time:~0,2%-%time:~3,2%-%time:~6,2%.dump" spider22
pg_dump --host 10.18.166.114 --port 60015 --username "postgres" --format custom --blobs --verbose --file "D:\databace\%PRJDB8%-%date:~0,4%-%date:~5,2%-%date:~8,2%-%time:~0,2%-%time:~3,2%-%time:~6,2%.dump" atplatform31
pg_dump --host 10.18.166.114 --port 60015 --username "postgres" --format custom --blobs --verbose --file "D:\databace\%PRJDB9%-%date:~0,4%-%date:~5,2%-%date:~8,2%-%time:~0,2%-%time:~3,2%-%time:~6,2%.dump" at_uacp
pg_dump --host 10.18.166.114 --port 60015 --username "postgres" --format custom --blobs --verbose --file "D:\databace\%PRJDB10%-%date:~0,4%-%date:~5,2%-%date:~8,2%-%time:~0,2%-%time:~3,2%-%time:~6,2%.dump" envsys
pg_dump --host 10.18.166.114 --port 60015 --username "postgres" --format custom --blobs --verbose --file "D:\databace\%PRJDB11%-%date:~0,4%-%date:~5,2%-%date:~8,2%-%time:~0,2%-%time:~3,2%-%time:~6,2%.dump" uacp
pg_dump --host 10.18.166.114 --port 60015 --username "postgres" --format custom --blobs --verbose --file "D:\databace\%PRJDB12%-%date:~0,4%-%date:~5,2%-%date:~8,2%-%time:~0,2%-%time:~3,2%-%time:~6,2%.dump" uacp_sjzx
pg_dump --host 10.18.166.114 --port 60015 --username "postgres" --format custom --blobs --verbose --file "D:\databace\%PRJDB13%-%date:~0,4%-%date:~5,2%-%date:~8,2%-%time:~0,2%-%time:~3,2%-%time:~6,2%.dump" vgs_sjzx
pause