PGCon2014 - Final Release

PGCon 2014
The PostgreSQL Conference

Syed Faisal Akber
Day Talks - Day 2 - Fri May 23 - 2014-05-23
Room Morisset 256
Start time 10:00
Duration 00:45
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