We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

An overview of PostgreSQL's backup, archiving and replication

Formal Metadata

Title
An overview of PostgreSQL's backup, archiving and replication
Subtitle
What to do, what not to do, where the pitfalls are
Title of Series
Number of Parts
611
Author
License
CC Attribution 2.0 Belgium:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language
Production Year2017

Content Metadata

Subject Area
Genre
Abstract
The PostgreSQL documentation explains in detail how to do backup andreplication, maybe too detailed for beginners or "part-time" DBAs. On the other hand, there are some common misconceptions about data safety. The talk gives a comprehensive, yet brief overview of the different approachesto perform backup/restore, point-in-time recovery and replication, advising onwhat to use in different scenarios. Some typical misconceptions and pitfalls are addressed as well.