~/talk

Tools for Creating PostgreSQL Backups

on YouTube 49m
TalkinRussianat HighLoad++ Moscow 2018 · 2018-11-08..11-09· [databases]

speaker

name:Andrey Salnikov
links:none on file

resources

video:https://youtu.be/Us6cHVNA4vk
slides:none on file

summary

A practical overview of PostgreSQL backup tools and strategies, comparing logical backups (pg_dump) and binary backups (pg_basebackup) plus built-in and third-party solutions. It covers when incremental backups are useful, how to choose tools like barman, wal-e, wal-g, pgbackrest, BART and pg_probackup, and how to automate backups and verify their integrity.

AI-written summary · about

chapters (10)

  1. 0:00Introduction
  2. 5:20Why backups matter
  3. 10:05PostgreSQL built-ins
  4. 15:23Incremental backups
  5. 20:47Backup modes
  6. 25:25Point-in-time recovery
  7. 30:13Automation and service
  8. 35:02Backup from replica pros and cons
  9. 40:50Backup validation
  10. 44:46Q&A

related talks

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.