
pg_probackup restore -B /home/postgres/pgbackup --instance=mybackup1 --recovery-target-time='2025-04-15 15:04:01'
INFO: Validating parents for backup SUPCLD
INFO: Validating backup SUJQS7
INFO: Backup SUJQS7 data files are valid
INFO: Validating backup SUPCLD
INFO: Backup SUPCLD data files are valid
INFO: Backup validation completed successfully on time 2025-04-15 15:10:25+08, xid 0 and LSN 1/8C000060
INFO: Backup SUPCLD is valid.
INFO: Restoring the database from backup at 2025-04-14 17:48:49+08
INFO: Start restoring backup files. PGDATA size: 1632MB
INFO: Backup files are restored. Transfered bytes: 1629MB, time elapsed: 1m:23s
INFO: Restore incremental ratio (less is better): 100% (1629MB/1632MB)
INFO: Syncing restored files to disk
INFO: Restored backup files are synced, time elapsed: 5s
INFO: Restore of backup SUPCLD completed.
[postgres@gbase8c_1 pg_wal]$ pg_probackup show -B /home/postgres/pgbackup/ --instance=mybackup1
========================================================================================================================================
Instance Version ID Recovery Time Mode WAL Mode TLI Time Data WAL Zratio Start LSN Stop LSN Status
========================================================================================================================================
mybackup1 12 SUQZVQ 2025-04-15 15:10:25+08 PAGE STREAM 15/15 1m:5s 872MB 32MB 1.00 1/8B000060 1/8C000128 OK
mybackup1 12 SUPCLD 2025-04-14 17:50:01+08 PAGE STREAM 15/15 1m:22s 873MB 48MB 1.00 1/88000028 1/890000F0 OK
mybackup1 12 SUJQS7 2025-04-11 17:11:06+08 FULL STREAM 15/0 1m:34s 943MB 16MB 1.00 1/6B000028 1/6B0001D8 OK
最后恢复完成后,数据不对,为什么没有使用2025-04-15 15:10:25 ,却使用了2025-04-14 17:50:01