opengauss 6.0.3 recovery_target_time 恢复不生效

步骤

1 全量+增量恢复

gs_probackup restore --instance opengauss15400 -B /data/backup/gs_pro -i T9TJ62 -D /data/opengaussdb/install/data/dn

2 cat>/data/opengaussdb/install/data/dn/recovery.conf<<EOF
recovery_target_time = ‘2026-02-02 14:24:06.100262+08’
recovery_target_inclusive = true
restore_command = ‘cp /data/opengaussdb/archlog/%f %p’
EOF

3 启动发现恢复的时间点数据不对

[omm@gaussrestore opengauss15400]$ gs_probackup restore --instance opengauss15400 -B /data/backup/gs_pro -i T9O8HV -D /data/opengaussdb/install/data/dn --recovery-target-time=‘2026-01-30 17:46:22’
LOG: Restore begin.
ERROR: Requested backup T9O8HV does not satisfy restore options

你指定的备份 ID T9O8HV不是可恢复到该时间点的有效备份,指定的恢复时间点是不是早于备份开始的时间?

gs_probackup 好像是不支持PITR恢复

gs_probackup 是支持 PITR 恢复的