Incremental Backup with PostgreSQL17

About

In this talk, we will explore the powerful incremental backup feature introduced in PostgreSQL 17. Rather than backing up the entire database, incremental backups focus on the changes made since the last backup. This approach significantly reduces time and storage requirements compared to full backups, making incremental backups an efficient, time-saving solution for data backup processes.

The talk will begin by explaining the fundamental concepts of incremental backups. We will then analyse how to handle retention over multiple backup increments. Finally, we will examine the key benefits of incremental backups, such as reduced backup times, lower storage costs and minimized impact on the database performance.

To provide a clear and practical understanding, I will present a series of examples and tests that we have conducted. These will illustrate how to implement and utilize incremental backups, making the concept easier to grasp.

0:00:00 Slide 1

0:01:38 Slide 2

0:02:10 Slide 3

0:02:57 Slide 4

0:04:12 Slide 5

0:05:33 Slide 6

0:06:41 Slide 7

0:07:09 Slide 8

0:07:57 Slide 9