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.
Getting ready
We will be continuing where we left off in the Setting up Bucardo recipe. Please make sure that you have completed that recipe before continuing. As usual, we will use the pgbench utility to create an initial set of tables. Execute this command on the primary PostgreSQL server as the postgres user if you haven't already done so:
pgbench -i postgresHow to do it...
As with all of the previous recipes, 192.168.56.30 will remain our replication subscriber...
