Skip to content

How long does it take to restore a database from a Point-in-Time backup (PITR)?

PIT修复所需的时间不是固定的。这取决于几个因素:

🌐 The time required for a PIT restoration isn't fixed. It depends on several factors:

自上次完整备份以来的时间:

完整备份每周进行一次。自上次完整备份以来的时间会影响恢复时间。

🌐 Full backups occur weekly. The time elapsed since the last full backup can affect restoration time.

预写式日志 (WAL) 活动:

自上次完整备份以来的 WAL 活动量是一个关键因素。活动越多,恢复时间可能越长。

🌐 The volume of WAL activity since the last full backup is a critical factor. More activity can lead to longer restoration times.

数据库大小:

虽然重要,但数据库规模并非恢复时间的唯一决定因素。

🌐 While important, the size of the database isn't the sole determinant of restoration time.