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.

Date:

2017 March 30 10:00 EDT

Duration:

50 min

Room:

Liberty III

Conference:

PGConf US 2017 [PgConf.US]

Language:

Track:

Use Cases

Difficulty:

Medium