Schedule - PGConf.EU 2014
Finding and Repairing Data Corruption
Date: 2014-10-23
Time: 11:50–12:40
Room: Renacimiento I
Level: Intermediate
It is, perhaps, the nightmare of every database administrator: Data corruption. Nothing substitutes for a good backup strategy, but sometimes, a great and desperate cure is required.
We'll discuss PostgreSQL's on-disk format, how corruption occurs, how to find it, and what the most effective ways of doing repairs are. And we'll talk about when to give up and go to the last backup.
