Restore your backups!

Presented by:

9925e18c0aef1b6574956603548cb7e7

Abhijit Menon-Sen

from 2ndQuadrant
No video of the event yet, sorry!

Download slides

How do Postgres backups work? What's really going on behind the friendly façade of Barman or pgBackRest or WAL-E? What's in this base backup, and how long is it going to take for your database to be up again?

This talk is an in-depth look at the mechanisms in Postgres to take backups, and how restoring from a backup actually works. Take a fresh look at checkpoints, consistency, point-in-time recovery, recovery targets, and other features. No matter which backup program you use, an understanding of the underlying concepts will help you avoid nasty surprises in a disaster-recovery situation.

Date:
2019 February 14 - 14:45
Duration:
45 min
Room:
Ballroom 1
Conference:
PGConf India, 2019
Language:
Track:
Database Administration
Difficulty:
Intermediate

Happening at the same time:

  1. Divide and Conquer data:- Advanced Methods for partitioning and sharding data - Latest developments
    2. Start Time:
    2019 February 14 14:45

    Room:
    Ballroom 4

  2. Knowing your data cluster and startup processes
    3. Start Time:
    2019 February 14 14:45

    Room:
    Ballroom 3