17 January 2020
CERN
Europe/Zurich timezone
There is a live webcast for this event.
Slides and Recording is available from the Timetable

Anastasia Lubennikova - Advanced PostgreSQL Backup and Recovery methods

17 Jan 2020, 16:15
50m
503/1-001 - Council Chamber (CERN)

503/1-001 - Council Chamber

CERN

162
Show room on map

Speaker

Anastasia Lubennikova

Description

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.

Presentation Materials