CERN Accelerating science

Talk
Title	Anastasia Lubennikova - Advanced PostgreSQL Backup and Recovery methods
Video	If you experience any problem watching the video, click the download button below Download Embed Mp4: Medium (1000 kbps) High (4000 kbps) More.. 800 kbps 800 kbps 800 kbps 1000 kbps 1000 kbps 2000 kbps 2000 kbps 2000 kbps 4000 kbps 4000 kbps Copy-paste this code into your page: <iframe width="640" height="360" frameborder="0" src="https://cds.cern.ch/video/2706980?showTitle=true" allowfullscreen></iframe> Copy-paste this code into your page to include both slides and lecture: <iframe src="https://mediastream.cern.ch/MediaArchive/Video/Public2/weblecture-player/index.html?year=2020&lecture=862805c2" width="1020px" height="600px" allowfullscreen scrolling="no" frameborder="0"></iframe>
Author(s)	Anastasia Lubennikova, (speaker)
Corporate author(s)	CERN. Geneva
Imprint	2020-01-17. - 0:45:54.
Series	(Visitor badges) (Postgres@CERN - PostgreSQL Meetup at CERN - January 17th)
Lecture note	on 2020-01-17T16:15:00
Subject category	Visitor badges
Abstract	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.
Copyright/License	© 2020-2024 CERN
Submitted by	franck.pachot@cern.ch