Chapter 15. Working with Walbouncer

In the final chapter of this book, you will be guided through a tool released in 2014, called walbouncer. Most of the techniques covered in this book have explained how to replicate an entire database instance, how to shard, and more. In the final chapter, which is about walbouncer, it's all about filtering the stream of the transaction log to selectively replicate database objects from one server to a set of (not necessarily identical) slaves.

The following topics will be covered in this chapter:

  • Basic concepts of walbouncer
  • Installing walbouncer
  • Selectively replicating databases, tables, and tablespaces

The walbouncer tool is available for PostgreSQL 9.4 or higher.

The concepts of walbouncer

The purpose of the PostgreSQL ...

Get PostgreSQL Replication - Second Edition 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.