PostgreSQL High Availability

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

PostgreSQL HA Methods

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

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

- HA Demo (with Failover)

- Upcoming Technologies:
-- Postgres-R
-- Postgres-XC