Database Reference
In-Depth Information
12
Replication &
Upgrades
In this chapter, we will cover the following:
F
Replication concepts
F
Replication best practices
F
Setting up file-based log shipping replication
F
Setting up streaming log replication
F
Managing log shipping replication
F
Managing Hot Standby
F
Selective replication using Londiste 3.0
F
Selective replication using Slony 2.0
F
Load balancing with pgpool II 3.0
F
Upgrading to a new minor release (for example, 9.0.0 to 9.0.1)
F
In-place major upgrades (for example, 8.4 to 9.0, or 9.0 to 9.1)
F
Major upgrades online using replication tools
Introduction
Replication isn't magic, though it can be pretty cool. It's even cooler when it works, and that's
what this chapter is all about.
Replication requires understanding, effort, and patience. There are a significant number of
points to get right. My emphasis here is on providing simple approaches to get you started,
and some clear best practices on operational robustness.
