Copying a few tables with Bucardo

Bucardo provides a very capable control mechanism in bucardo. Unlike Slony, which depends on an arcane programming language to create new replication sets and subscriptions, Bucardo is much more straightforward. As with Slony, we still want to copy data to other servers to avoid overwhelming our primary server.

In this recipe, we will utilize bucardo to create what Bucardo refers to as a relgroup. Bucardo herds contain one or more tables, and they are the basis of its synchronization system.

Let's begin.

Get PostgreSQL High Availability Cookbook - 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.