Stefan Fercot:pgBackRest 差异备份与增量备份
原文英文,约700词,阅读约需3分钟。发表于: 。One of the most frequent questions I get is to actually explain the difference between differential and incremental backups in pgBackRest. As everyone might easily imagine, an incremental...
在pgBackRest中,增量备份只复制自上次成功备份以来已修改的数据库文件,而差异备份是基于上次成功的完整备份进行的。增量备份更快但差异备份更可靠。恢复时,增量备份依赖于前一个增量备份的文件数量,而差异备份只需完整备份的文件。备份时需注意WAL归档文件的重要性,用于保持一致性和时间点恢复。如果最新备份损坏,只需有所有WAL归档文件,可从之前备份中恢复。