[Bucardo-general] Bringing up a new Bucardo installation

[Christophe Pettus]

Hi,

We're about to start using Bucardo to do replication from a master to a slave PG 9.0 database (we're using Bucardo instead of 9.0 SR as the slave's tables are a superset of the master's, and the additional tables on the slave need to stay writeable).

The master and slave databases are each in their own cluster, and are the only (user) databases in each cluster; they're on different servers.  All of the user tables on the master will be replicated to the slave.

My understanding of how to bring up the replication between them goes like this:

1. Create the slave database (using pg_dumpall --schema-only from the master to the slave).
2. Install Bucardo on the slave db (let's assume we'll be running the Bucardo daemons on the slave db machine).
3. Create an all-tables pushdelta sync from the master to the slave, but don't fire up Bucardo's daemon just yet.
4. Using pg_dump, copy the data from the master to the slave, excluding the master's "bucardo" schema.
5. Start up Bucardo (bucardo_ctl start) to run the sync from the master to slave.

I think we're done at that point.  Does that seem correct?

Thanks so much!
--
-- Christophe Pettus
   xof at thebuild.com