[Bucardo-general] Bucardo-general Digest, Vol 53, Issue 2

[Jonathan Brinkman]

I agree that is confusing. If all my tables are in a particular sync, how
can up do a onetimecopy to a single table in that sync?

Consider:
bucardo_ctl update sync <syncname> onetimecopy=2

That command would seem to update ALL tables in a particular sync, which
seems the same as the onetimecopy=1

Does this work?
bucardo_ctl update table <tablename> onetimecopy=2


-----Original Message-----
From: bucardo-general-bounces at bucardo.org
[mailto:bucardo-general-bounces at bucardo.org] On Behalf Of
bucardo-general-request at bucardo.org
Sent: Friday, February 10, 2012 7:00 AM
To: bucardo-general at bucardo.org
Subject: Bucardo-general Digest, Vol 53, Issue 2

Send Bucardo-general mailing list submissions to
	bucardo-general at bucardo.org

To subscribe or unsubscribe via the World Wide Web, visit
	https://mail.endcrypt.com/mailman/listinfo/bucardo-general
or, via email, send a message with subject or body 'help' to
	bucardo-general-request at bucardo.org

You can reach the person managing the list at
	bucardo-general-owner at bucardo.org

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Bucardo-general digest..."


Today's Topics:

   1. table syncing after type pushdelta has been set (jtkells)


----------------------------------------------------------------------

Message: 1
Date: Thu, 09 Feb 2012 16:11:44 -0500
From: jtkells <jtkells at verizon.net>
Subject: [Bucardo-general] table syncing after type pushdelta has been
	set
To: bucardo-general at bucardo.org
Message-ID: <20120209161144.04e4e770 at ubuntu>
Content-Type: text/plain; charset=US-ASCII


Hello,

I am new to Bucardo and have set up a testing replication environment.
So far everything is looking good.  I do have a question concerning
syncing a table.  The documentation states:

          If the target table is *not* empty,
          but is not identical to the source, the best way to get them
          in sync is to truncate or delete all the rows from the slave,
          and then set onetimecopy to a value of 2. (While you can do
          the same thing by simply setting it to 1, that will also copy
          over all the rows for every other table in the sync).

           To change the onetimecopy value of a sync, just run:

          bucardo_ctl update sync <syncname> onetimecopy=2

I'm a little confused about the difference between a value of 1 verses
2.  Could someone explain the difference?  Also, I will have over a
hundred tables within a schema to replicate and some of these tables
have a lot of rows (600,000+).  Is there a way to get to a sync state
without deleting all the data.  Even though this should be an
occasional task the amount of data to be copied combined with the
number of tables will have an effect on the applications on the slave
node by either having an outage window or missing data for a period of
time.

Thanking you in advance
John


------------------------------

_______________________________________________
Bucardo-general mailing list
Bucardo-general at bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general


End of Bucardo-general Digest, Vol 53, Issue 2
**********************************************