402 Star 1.4K Fork 1.5K

GVPopenGauss / openGauss-server

 / 详情

gs_probackup 备份建议使用复制槽

设计中
需求
创建于  
2023-08-30 16:29

【需求背景】

【需求描述】

默认max_replication_slots=8
select * from pg_get_replication_slots(); -- 空
SELECT * FROM pg_create_physical_replication_slot('slot1_1162691', false);
SELECT * FROM pg_create_physical_replication_slot('slot2_1162691', false);
SELECT * FROM pg_create_physical_replication_slot('slot3_1162691', false);
SELECT * FROM pg_create_physical_replication_slot('slot4_1162691', false);
SELECT * FROM pg_create_physical_replication_slot('slot5_1162691', false);
SELECT * FROM pg_create_physical_replication_slot('slot6_1162691', false);
SELECT * FROM pg_create_physical_replication_slot('slot7_1162691', false);
SELECT * FROM pg_create_physical_replication_slot('slot8_1162691', false);
select count(*) from pg_get_replication_slots(); -- 8个

--1. 初始化备份目录
gs_probackup init -B /home/openguass/probackup_1162691
--2. 增加备份实例
--获取ss_dss_conn_path
gs_probackup add-instance -B /home/openguass/probackup_1162691 -D $PGDATA --instance backup_1162691 --enable-dss --instance-id 0 --vgname='+data,+p0' --socketpath="UDS:/opt/og20230216/install/data/dss/.dss_unix_d_socket"
--3. 创建指定实例的备份,对主机进行备份
gs_probackup backup -B /home/openguass/probackup_1162691 --instance backup_1162691 -b full -d postgres -p $PGPORT

当前做法:没有使用逻辑复制槽,在复制槽占满的情况下,仍然备份成功

需求:gs_probackup建议使用逻辑复制槽进行备份,直接读取数据,这样有风险。
极端情况可能导致备份出来的数据不全。比如最开始说要备份1-10这几个xlog,但因为没有复制槽,系统不知道要保留这些xlog,就可能被删除。

【其他说明】

评论 (2)

roxanne315 创建了需求

Hey @roxanne315, Welcome to openGauss Community.
All of the projects in openGauss Community are maintained by @opengauss_bot.
That means the developers can comment below every pull request or issue to trigger Bot Commands.
Please follow instructions at Here to find the details.

Hi @roxanne315, please use the command /sig xxx to add a SIG label to this issue.
For example: /sig sqlengine or /sig storageengine or /sig om or /sig ai and so on.
You can find more SIG labels from Here.
If you have no idea about that, please contact with @xiangxinyong , @zhangxubo .

登录 后才可以发表评论

状态
负责人
项目
里程碑
Pull Requests
关联的 Pull Requests 被合并后可能会关闭此 issue
分支
开始日期   -   截止日期
-
置顶选项
优先级
预计工期 (小时)
参与者(2)
13084139 opengauss bot 1686829535
C++
1
https://gitee.com/opengauss/openGauss-server.git
git@gitee.com:opengauss/openGauss-server.git
opengauss
openGauss-server
openGauss-server

搜索帮助