Conference Schedule - PGConf.EU 2018

Dig the WAL

Date: 2018-10-23
Time: 13:30 - 17:00
Room: Berlin B
Level: Intermediate

PostgreSQL relies on WAL for operation logging. But what will DBA be able to achieve if WAL get corrupted ?

This hands-on training aims to push the user to different situations where WAL should be dug in order to recover from disasters.

This training will first explain different kinds of WAL levels and contents, then an overview of the PostgreSQL different tools (pg_resetwal and pg_rewind) will be explained. Trainees will face situations they'll have to solve using PostgreSQL common tools in order to recover, just for fun and learning...

Prerequisites are :

  • PostgreSQL administration skills
  • Linux command line and psql knowledege
  • VirtualBox must be installed, up and running (VMs will be provided)

Slides

The following slides have been made available for this session:

Speaker

Jean-Christophe Arnu
Stéphane Schildknecht