O'Reilly logo

PostgreSQL 9 Administration Cookbook by Hannu Krosing, Simon Riggs

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 12. Replication & Upgrades

In this chapter, we will cover the following:

  • Replication concepts
  • Replication best practices
  • Setting up file-based log shipping replication
  • Setting up streaming log replication
  • Managing log shipping replication
  • Managing Hot Standby
  • Selective replication using Londiste 3.0
  • Selective replication using Slony 2.0
  • Load balancing with pgpool II 3.0
  • Upgrading to a new minor release (for example, 9.0.0 to 9.0.1)
  • In-place major upgrades (for example, 8.4 to 9.0, or 9.0 to 9.1)
  • 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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required