PGCon2014 - Final Release
PGCon 2014
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Syed Faisal Akber |
| Schedule | |
|---|---|
| Day | Talks - Day 2 - Fri May 23 - 2014-05-23 |
| Room | Morisset 256 |
| Start time | 10:00 |
| Duration | 00:45 |
| Info | |
| ID | 678 |
| Event type | Lecture |
| Track | Hacking |
| Language used for presentation | English |
What Do You Mean my Database Server Core Dumped?
How to Inspect Postgres Core Dumps
Program crashes are a fact of life and occasionally unavoidable. If there are core dumps that get generated then understanding what happened becomes easier.
Using log files and the core dump it is possible to identify what piece of data or code that may have triggered the problem.
This introductory talk will cover:
* What is a core dump?
* Methods to generating a core dump
* How to inspect the contents of a core dump
* Tools used to inspect core dumps
* How to obtain basic information from the core dump
* Analyzing the information gathered
* How to apply these techniques to Postgres
* How to make sense of what Postgres is doing
* Topics to research after the presentation on the subject of Postgres hacking and core dump analysis
* A case study of a particular Postgres crash