Kurs: RLPG109 - PostgreSQL 9.0 Replication and Hot Standby

PostgreSQL 9.0 comes with new functions for streaming binary replication, improving the existing Warm Standby solutions of previous versions, and Hot Standby that allows opening up the slave side of binary replication for read access.

The session last approximately 3.5 hours - from 12:30 to 16:00.

This session will start with a recap of the existing Warm Standby technology, and then move on to the changes in 9.0 for building both Warm and Hot standby solutions. We'll look at how to set the system up, ensure it's working, and discuss the different tradeoffs that have to be made. Attendees are expected to have a basic understanding of PostgreSQL, approximately at the level of the PostgreSQL DBA course.