PGCon2017 - 20180510
PGCon 2017
The PostgreSQL Conference
Speakers | |
---|---|
Christophe Pettus |
Schedule | |
---|---|
Day | Talks - Day 1 - 2017-05-25 |
Room | DMS 1110 |
Start time | 10:00 |
Duration | 00:45 |
Info | |
ID | 1048 |
Track | Case Studies |
Language used for presentation | English |
Corruption War Stories
Real-Life Corruption Issues and Recovery
An overview of real-life instances of corruption, and how each was handled.
Every instance of database corruption is unique. In this talk, we'll talk about some specific, real-world examples of PostgreSQL database corruption, and how they were repaired. We'll step through each one with how we detected it, how we isolated the issue, and what we did to patch it... and what did and didn't work.
We'll also go over how to avoid those specific issues, and general approaches to managing database corruption in PostgreSQL.