[Bucardo-general] Bringing up a new Bucardo installation

[Christophe Pettus]

On Jun 13, 2011, at 9:03 AM, Greg Sabino Mullane wrote:

>> 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?
> 
> Close - you need to make sure the triggers are installed on the master before you do the 
> pg_dump of the data in step 4. So a step 3.5 should be:
> 
> 3.5. Run 'bucardo_ctl validate all' and make sure the triggers are creaed on the master.

Great, thank you!  My understanding is that step 3 (creating the sync) installs the triggers on the master, and nothing need be installed on the slave (the bucardo daemon handles the pushing to the slave).  Is that so?

--
-- Christophe Pettus
   xof at thebuild.com