[Bucardo-general] Bringing up a new Bucardo installation

[Greg Sabino Mullane]

> 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.

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20110613/4c15ad40/attachment.bin