PGCon2017 - 20180510

PGCon 2017
The PostgreSQL Conference

Christophe Pettus
Day Talks - Day 1 - 2017-05-25
Room DMS 1110
Start time 10:00
Duration 00:45
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.