Chapter 7. Replication Management Tools

In this chapter, we will learn where to turn when management of large PostgreSQL clusters becomes a concern. We will cover the following recipes in this chapter:

  • Deciding when to use third-party tools
  • Installing and configuring Barman
  • Backing up a database with Barman
  • Restoring a database with Barman
  • Installing and configuring OmniPITR
  • Managing WAL files with OmniPITR
  • Installing and configuring repmgr
  • Cloning a database with repmgr
  • Swapping active nodes with repmgr
  • Installing and configuring walctl
  • Cloning a database with walctl
  • Managing WAL files with walctl

Introduction

When it comes to maintaining a single PostgreSQL cluster with a single source of WAL files, our job is an easy one. Even a small number of streaming ...

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.