Data Recovery in PostgreSQL on a damaged filesystem
Chris Travers works in Berlin as a database administrator, in a distributed PostgreSQL environment involving hundreds of TB of data in PostgreSQL. He has experience working with PostgreSQL in many areas from scientific computing in the life sciences, to ERP, from high-velocity ad-tech analytics to geo-spacial databases. He is the author of a number of extensions on pgxn.
His current experience involves mobile advertisement analytics over 400TB data sets and more short-terms log management environments handling PBs of data in PostgreSQL.
No video of the event yet, sorry!
After a power outage took all our db servers offline suddenly, two of them failed to come back. We decided to do data recovery on these systems in order to reduce the amount of data loss. This talk will focus on both the technical and non-technical aspects of data recovery used, and what anyone should be aware of when trying to recover data from PostgreSQL.
We will discuss the causes of the corruption we faced, what we recovered, and how we went about recovering the data we decided to go after.
- 2018 October 15 16:40
- 50 min
- Silicon Valley