Anastasia Lubennikova - Advanced PostgreSQL Backup and Recovery methods

About

As database size and complexity grow, DBAs may face the fact that the functionality offered by built-in tools such as pg_dump and pg_basebackup is insufficient, and more flexibility is required to create reliable backups and manage them. This talk cover various advanced topics in the area of backups: - incremental backups; - archive management; - backup validation; - retention policies; etc. Based on these features, we'll compare various backup/recovery solutions for PostgreSQL. This information will help you to choose the most appropriate tool for your system.

Anastasia Lubennikova received her B.S. degree in Applied Mathematics and Information Science from NRNU MEPhI. She has 5 years of experience as a system software developer and speaker. She also worked as a teacher and project manager in a database systems domain.

As a PostgreSQL contributor, Anastasia focuses on optimizing indexing, storage, and backup solutions. She enjoys working with both open source community and enterprise projects, as they provide different perspectives on the same product. Contributing to open source allows to improve the system used by millions of users and collaborate with the best professionals in the field all around the world. While working on software custom development and tech support provides constant challenges, not only technical ones and connects the art of system development with real business needs..

0:00:00 Slide 1

0:00:37 Slide 2

0:01:27 Slide 3

0:02:53 Slide 4

0:05:46 Slide 5

0:05:56 Slide 6

0:07:07 Slide 7

0:08:16 Slide 8

0:08:51 Slide 9