Presented by:

280e9929e61b4577abf017d2901b26be

Veenadhari Popuri

Google LLC

a PostgreSQL enthusiast - have been working with open source databases on major clouds like Google and AWS

No video of the event yet, sorry!

PostgreSQL 17 introduces a game-changing feature: incremental backups. This presentation provides a deep dive into this highly anticipated functionality, demonstrating how it revolutionizes database backup strategies. Topics: The Mechanics of Incremental Backups: We'll explore how pg_basebackup with the --incremental option captures only changed data blocks since the last backup, significantly reducing backup sizes and durations. WAL Summary Files: Understand the role of WAL summary files in optimizing incremental backup efficiency. pg_combinebackup Utility: Learn how to merge a base backup with its incremental backups using this new tool, facilitating full backup reconstruction. Practical Implementation: Witness a live demonstration of creating, managing, and restoring from incremental backups. Best Practices: Gain insights into configuring and integrating incremental backups into your existing backup strategy for optimal performance and recovery times. This session is ideal for database administrators, DevOps engineers, and anyone responsible for managing PostgreSQL backups. Leave equipped with the knowledge and skills to leverage this powerful new feature and enhance your data protection strategy.

Date:
Duration:
20 min
Room:
Conference:
Postgres Conference 2025
Language:
Track:
Essentials
Difficulty:
Medium