Streaming replication and Hot Standby

Training type: 
Half day training
Technical Level: 

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.

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.

Assuming the tree has stabilized, a short preview of the features coming up in 9.1 will be included.