PGCon2012 - Final Release

PGCon 2012
The PostgreSQL Conference

Phillip Sorber
Day Tutorials - 2 - Wednesday - 2012-05-16
Room MRT 212
Start time 09:00
Duration 03:00
ID 493
Event type Workshop
Track DBA
Language used for presentation English

Getting Hot and Streamy with Postgres

Using Postgres' built in replication facilities

An overview of Postgres' built in replication system, starting from PITR and going to cascading replication with demonstration's along the way. There will be more emphasis on the more recent and interesting technologies such as streaming replication and hot standby.

Starting off with background about the WAL and how it enables all the technologies I am going to describe. Moving on to PITR, Warm Standby, Streaming Replication, Hot Standby, Synchronous Streaming Replication and Cascading Replication. I will have demonstrations along the way that will build on each other as we get toward the more advanced methods. Most of the focus will be on the most practical Streaming Replication and Hot Standby. The goal is that someone watching this tutorial would be able to understand enough about how replication works in Postgres to implement and maintain it.