# Anastasia Lubennikova - Advanced PostgreSQL Backup and Recovery methods

- Institution: CERN
- Department: Visitor badges
- Speaker: Anastasia Lubennikova,
- Year: 2020
- Language: English
- Source: [CERN](https://videos.cern.ch/record/3010443)
- Licence: [CERN](http://copyright.web.cern.ch)
- Who can watch: Teens profiles and older (sources give no ratings; placed by Invisible Network from the source's own words)

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

0:09:57 Slide 10

0:10:45 Slide 11

0:10:58 Slide 12

0:12:17 Slide 13

0:13:10 Slide 14

0:14:46 Slide 15

0:15:20 Slide 16

0:15:59 Slide 17

0:16:29 Slide 18

0:16:51 Slide 19

0:17:47 Slide 20

0:18:21 Slide 21

0:18:46 Slide 22

0:19:40 Slide 23

0:20:12 Slide 24

0:20:50 Slide 25

0:21:33 Slide 26

0:22:44 Slide 27

0:23:37 Slide 28

0:24:45 Slide 29

0:26:10 Slide 30

0:26:56 Slide 31

0:29:03 Slide 32

0:30:12…

## Lectures

1. [Anastasia Lubennikova - Advanced PostgreSQL Backup and Recovery methods](https://invisiblenetwork.ai/learn/cern/3010443/ce724a05176f), 46 min (CERN's player)