PGCon2012 - Final Release
PGCon 2012
The PostgreSQL Conference
| Speakers | |
|---|---|
|
Phillip Sorber |
| Schedule | |
|---|---|
| Day | Tutorials - 2 - Wednesday - 2012-05-16 |
| Room | MRT 212 |
| Start time | 09:00 |
| Duration | 03:00 |
| Info | |
| 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.