An's Blog
收藏、分享 …
Toggle navigation
Home
Cesium
SuperMap
ArcGIS
MapboxGL
CentOS
GeoServer
Favorites
Archives
Tags
PostgreSQL数据库备份和恢复
2023-02-21 10:44:07
11
0
0
admin
### 一、数据备份 pg_dump -h 127.0.0.1 -U postgres iportal > D:\iportal-230221.bak ### 二、数据恢复 psql.exe -h 127.0.0.1 -U postgres -d iportal < D:\iportal-230221.bak ### 三、自动备份脚本(Windows) #### **1、编写备份脚本** @ECHO OFF @setlocal enableextensions @cd /d "%~dp0" SET PGPASSWORD=thth@1212 SET SVPATH=D:\DataBack\ SET PRJDB=iportal SET DBUSR=postgres SET DirName=%date:~0,4%%date:~5,2% @if %date:~8,2% == 01 (md "%SVPATH%%DirName%") @if not exist "%SVPATH%%DirName%" (md "%SVPATH%%DirName%") SET DBDUMP=%PRJDB%_%date:~0,4%%date:~5,2%%date:~8,2%_%time:~1,1%%time:~3,2%%time:~6,2%.bak @ECHO OFF pg_dump -h localhost -U postgres %PRJDB% > %SVPATH%%DirName%\%DBDUMP% echo 数据库备份完成,存放路径:%SVPATH%%DirName%\%DBDUMP% @ECHO ON 效果图如下:  [AutoBackup.bat](/api/file/getAttach?fileId=63f463099a54ae02220000f9) #### **2、创建"任务计划程序"** **(1) 打开“管理工具” $\rightarrow$ “任务计划程序”,如下图所示:**  **(2) 创建基本任务向导,按每日0时0分执行,如下图所示:**  
Pre:
SuperMap iPortal门户安全性最佳做法
Next:
ESXI中给虚拟机添加物理网卡
0
likes
11
Weibo
Wechat
Tencent Weibo
QQ Zone
RenRen
Table of content