PostgreSQL HA Methods

Talk Type: 
90 Minute Mini-Tutorial
Track: 
Replication/HA
Technical Level: 
Intermediate
License: 
BSD

This will be a 90 minute Mini-Tutorial on PostgreSQL High Availability.
We'll cover a number of HA building blocks such as Warm/Hot Standby and
connection pooling, then we'll spend some time looking at HA architectures and
specific scenarios. Topics include:

- Warm Standby
- Hot Standby
- SLONY
- PG POOL II
- pg_bouncer
- IP Alias Management
- Bucardo

- Putting it all together (HA Architectures & Scenarios)
- Failover Switchover and Reset

- HA Walkthrough of at least one end 2 end solution (with Failover)

- We'll also cover some upcoming technologies:
-- Postgres-R
-- Postgres-XC