gs_probackup对物理备份gs_basebackup的增强
- 支持PTRACK增量备份
- 支持增量恢复：基于页级增量恢复
- Merge合并：合并增量备份
- 数据备份有效性自动检测，无需实际的数据恢复
- 数据库实例checksum检测(需要打开checksum）
- 备份保留策略：按时间或数量保留WAL归档及备份
- 多线程并行化：支持backup、restore、merge等命令
- 支持远程操作：支持SSH方式远程备份或恢复实例
- 支持从standby备份，避免主库额外负载压力
- 数据存储在外部目录：与PGDATA保持独立
- 备份元数据管理：命令配置持久化到文件
开启配置
使用PTRACK增量备份，需在postgresql.conf中手动添加参数“enable_cbm_tracking = on”。
gs_guc reload -D /opt/mogdb/data -c "enable_cbm_tracking = on"
需要开启归档
初始化备份路径
gs_probackup init -B /data/backup_dir/
会在指定路径下生成backups和wal两个文件夹
初始化备份实例
在备份路径backup-path内初始化一个新的备份实例，并生成pg_probackup.conf配置文件，该文件保存了指定数据目录pgdata-path的gs_probackup设置。
gs_probackup add-instance -B /data/backup_dir -D /opt/mogdb/data --instance instance_local
在路径/data/backup_dir/backups/instance_local下生成pg_probackup.conf配置文件
全备
gs_probackup backup -B /data/backup_dir --instance instance_local -d postgres -b FULL
INFO: Backup start, gs_probackup version: 2.4.2, instance: instance_local, backup ID: SUFXAM, backup mode: FULL, wal mode: STREAM, remote: false, compress-algorithm: none, compress-level: 1
LOG: Backup destination is initialized
LOG: This openGauss instance was initialized with data block checksums. Data block corruption will be detected
LOG: Database backup start
LOG: started streaming WAL at 1/17000000 (timeline 1)
[2025-04-09 15:39:58]: check identify system success
[2025-04-09 15:39:58]: send START_REPLICATION 1/17000000 success
[2025-04-09 15:39:58]: keepalive message is received
[2025-04-09 15:39:58]: keepalive message is received
INFO: PGDATA size: 649MB
INFO: Start transferring data files
LOG: Creating page header map "/data/backup_dir/backups/instance_local/SUFXAM/page_header_map"
INFO: Data files are transferred, time elapsed: 3s
INFO: wait for pg_stop_backup()
INFO: pg_stop backup() successfully executed
LOG: stop_lsn: 1/170001E8
LOG: Looking for LSN 1/170001E8 in s