# Incremental Backup with PostgreSQL17

- Institution: CERN
- Speaker: Marion Baumgartner
- Year: 2026
- Language: English
- Source: [CERN](https://videos.cern.ch/record/3020774)
- Licence: [CERN](https://copyright.web.cern)
- Who can watch: Teens profiles and older (sources give no ratings; placed by Invisible Network from the source's own words)

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

0:08:57 Slide 10

0:09:28 Slide 11

0:10:31 Slide 12

0:11:20 Slide 13

0:12:33 Slide 14

0:12:44 Slide 15

0:13:08 Slide 16

0:13:20 Slide 17

0:14:43 Slide 18

0:15:31 Slide 19

0:17:12 Slide 20

0:18:05 Slide 21

0:18:56 Slide 22

0:19:29 Slide 23

0:20:36 Slide 24

0:23:22 Slide 25

0:23:51 Slide 26

0:26:29 Slide 27

0:29:06 Slide 28r>

## Lectures

1. [Incremental Backup with PostgreSQL17](https://invisiblenetwork.ai/learn/cern/3020774/52a13c90cd98), 31 min (CERN's player)