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