Chapter 6. Replication

In this chapter, we will learn several methods to copy entire databases or individual tables. We will cover the following recipes in this chapter:

  • Deciding what to copy
  • Securing the WAL stream
  • Setting up a hot standby
  • Upgrading to asynchronous replication
  • Bulletproofing with synchronous replication
  • Faking replication with pg_receivexlog
  • Setting up Slony
  • Copying a few tables with Slony
  • Setting up Bucardo
  • Copying a few tables with Bucardo
  • Setting up Londiste
  • Copying a few tables with Londiste

Introduction

One element that is absolutely required for any highly available PostgreSQL installation is replication. It does not matter if we have a SAN that provides disk redundancy, nor is DRBD or other block-level replication sufficient to protect ...

Get PostgreSQL 9 High Availability Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.