-- pg备份命令
pg_dump -h 172.2.0.21 -p 5435 -U postgres -Ft -b -v -c -f yidian_kg_240612.tar yidian_kg
-- pg还原命令 
pg_restore -h 172.2.0.21 -p 5435 -U postgres -Ft -v -O -d yidian_kg_240612_backup yidian_kg_240612.tar

一、服务器及数据库配置

全国地址库及知识库23q1:

database: AddressDB_23q1
user: postgres
password: wayzpg@1234tes
host: 172.2.0.21
port: 5435

堡垒机：

https://jump.newayz.com/ui/#/

host: jump.newayz.com
port: 2222
user: xiaoyuan.ju
password: Abc@1234

172.3.0.153服务器:

host : 172.3.0.153
user : root
password: wayz@1234

172.2.0.21服务器:

host: 172.2.0.21
user: root
password: wayz@1234

仪表盘连接数据库:

host: 10.70.17.21
port: 5432
user: postgres
db: address_data
username:  postgres
password:  wayzgipostgresql

lai生产环境京东云：

-h pg-east2-bafc8689a46747e5.rds.jdcloud.com 
-p 5432 
-U location 
-d address_elements_20230727
password:Wayz2021

二、迁库流程梳理

2.1 以.sql文件备份(首选)

以172.2.0.21服务器address_elements_20230727数据库备份到lai生产环境生产环境为例