Re: [Bucardo-general] Three nodes, with two independent syncs. Possible?

On Wed, Jul 29, 2015 at 4:01 PM, John Jeffers wrote: > Given that I already have a sync from CURRENT to TARGET, can I safely set > up a sync from TARGET to FAILSAFE without disrupting with the first sync? > Yes. You'll want to enable "makedelta" on the first sync, from CURRENT to TARGET. Doing t

Re: [Bucardo-general] doubts about target db?

On Thursday, October 13, 2016, Periko Support wrote: > > 1) My target db must have all the tables created without data on it > before sync? Yes, tables must exist on the target. Generally, it's easiest to have them empty, but the bigger concern is conflicts with data from the master. > 2) In a

Re: [Bucardo-general] Strange log errors after upgrade Wheezy to Jessie

On Thu, Oct 20, 2016 at 11:03 AM, Paul Theodoropoulos wrote: > So now I'm concerned, but maybe I'm misunderstanding something - the > documents, and the bucardo code, make many references to table > 'bucardo_delta'.but there is no bucardo_delta table listed in the db?? The delta tables can

Re: [Bucardo-general] ubuntu 14 /var/run/bucardo issue and startup batch

On Thu, Oct 20, 2016 at 1:42 PM, Periko Support wrote: > can some one share me his startup batch for ubuntu? /etc/init.d? There are example init-scripts that ship with the standard Bucardo distribution. Look under the dist directory in the git repo. Once installation, I chose /var/run/bucardo,

Re: [Bucardo-general] ubuntu 14 /var/run/bucardo issue and startup batch

On Thursday, October 20, 2016, David Christensen wrote: > > > On Oct 20, 2016, at 5:27 PM, Rosser Schwarz > wrote: > > It looks like the sample init-scripts don't test for the existence of > $PIDDIR, which might be worth patching. Assuming it's portable, a `mk

Re: [Bucardo-general] Recover bucardo "hole" in sync

On Fri, Jan 6, 2017 at 2:31 AM, Laurent GARCES wrote: > Could someone advice us a safe way to do this? If I understand your problem correctly, the fix is pretty simple. It sounds like the data the third host is missing should exist on (at least one of) the other two, is this correct? If so, an

Re: [Bucardo-general] Sync Issues.

On Fri, Jan 20, 2017 at 10:44 Periko Support wrote: > Exist a way to fix this or we have to manually fix the db? I believe you can get around this issue by disabling the strict_checking option (I think that's the name) on your sync. You can also do mildly dangerous things like swapping "attnum"

Re: [Bucardo-general] Anyway to Increase log output for ONETIMECOPY?

On Thu, Jan 26, 2017 at 13:20 Donald StDenis wrote: So any way to get a table by table logging of the ONETIMECOPY? > I don't think you can selectively increase the verbosity of the logging for just onetimecopy functionality without touching the code. That said, it shouldn't be too difficult to

Re: [Bucardo-general] Adding a database with failed connection

On Mon, Jun 19, 2017 at 4:00 PM, Logan, Sean wrote: > Is this scenario feasible or do we need to ensure both servers are up and > running before we attempt to configure the bucardo install? > The latter. Postgres needs to be installed and running on both sides of the sync that will exist between

Re: [Bucardo-general] target table trigger not fired

On Tue, Jun 12, 2012 at 2:51 PM, Will wrote: > One thing I'd like to do is to record the time stamp when a row is > replicated over to the subscriber. I created a trigger on the table on > the subscriber, hoping when the row is inserted, the trigger would > modify the timestamp column and then the

Re: [Bucardo-general] Is Bucardo appropriate for this situation....

On Sun, Jul 15, 2012 at 5:00 AM, Martin Bramwell wrote: > I found Bucardo earlier today by googling "Postgres bidirectional > replication", and I'd like to ask if it is suited to a situation I have in > mind. Yes, Bucardo is fairly ideally suited for your use-case. It was originally developed to

Re: [Bucardo-general] master slave not syncing after db upgrade. (triggers disabled)

Can you connect to your Bucardo database and say "SELECT validate_all_syncs();" and report what happens? rls On Mon, Aug 6, 2012 at 3:57 PM, jtkells wrote: > On Mon, 6 Aug 2012 09:27:32 -0400 > jtkells wrote: > >> Hi, >> >> I'm having a bit of trouble here getting a master to slave replication

Re: [Bucardo-general] [SOLVED] b5 / pg84 : "arguments of row IN must all be row expressions"

On Wed, Sep 19, 2012 at 1:26 PM, Bill McGonigle wrote: > On 09/19/2012 03:39 PM, Bill McGonigle wrote: >> Will see where that's generated next... > I didn't quite figure out the code but I got far enough to understand what > was happening. I think this is probably a reportable bug in b5. I thin

Re: [Bucardo-general] Connection Pooling

On Tue, Oct 2, 2012 at 5:14 PM, David E. Wheeler wrote: > If Bucardo uses transactions to move data around en mass, I think I would > use transaction pooling. Bucardo is transactional. rls -- :wq ___ Bucardo-general mailing list Bucardo-general@buc

Re: [Bucardo-general] Connection Pooling

On Tue, Oct 2, 2012 at 8:35 PM, Greg Sabino Mullane wrote: >> Which type of pooling should I use: transaction or statement? > Certainly not statement! And be careful with transaction as well. Doesn't pgBouncer also support session-level pooling? Would that be more appropriate? rls -- :wq

Re: [Bucardo-general] Burcardo.pm 4.4.8 crashed on small systems - patch attached

I can't speak to your proposed algorithmic changes, but I do think chunk size should maybe be configurable, to help deal with low-memory environments like the OP's, and to allow DBAs to set larger chunk sizes, when they've also set max_stack_depth and the relevant ulimits accordingly. On Fri, Dec

Re: [Bucardo-general] statement_chunk_size

Jonathan Brinkman wrote > How does one reduce the statement_chunk_size to 1000 from 1? $ bucardo set statement_chunk_size=1000 rls -- :wq ___ Bucardo-general mailing list Bucardo-general@bucardo.org https://mail.endcrypt.com/mailman/listinfo/buca

Re: [Bucardo-general] Sync stopped due to ERROR: could not serialize access due to concurrent update

jbk wrote: > ...could not serialize access due to concurrent update... > Any idea? This is a noise warning. Bucardo will simply retry until the row(s) in question have successfully been replicated. 4.4.0 is pretty old — around four years old at this point, I think. If you need to stay on the 4

Re: [Bucardo-general] Simple question regarding master-master

Bucardo only needs to be installed on one host, although obviously, that won't provide HA capability. Typically, in a master-master scenario, it's installed on one of the masters. In the event either of the masters then goes down, the Bucardo daemon wouldn't have anything to do anyway, so HA for it

Re: [Bucardo-general] Can bucardo do this?

No, Bucardo can't "detect" that the data in the two locations is semantically different, and that it shouldn't be overwritten, but instead modified so as not to conflict. (As far as I know, no replication system in the world can do that.) If you updated something on BR_HR's record with id = 1, then

Re: [Bucardo-general] One Way Syncs

Take a look at . I believe the db:{source|target} syntax described there works for "add database" as well, but I don't have a running instance to very against handy. rls On Thu, Mar 6, 2014 at 12:09 PM, Balman, Matthew D. (GSFC-428.0)[Embedded Flight Systems,

Re: [Bucardo-general] ERROR: duplicate key value violates with master master replication

On Tue, May 13, 2014 at 10:47 PM, Juned Khan wrote: > On Thu, May 8, 2014 at 12:59 PM, Juned Khan wrote: > >> DETAIL: Key (id)=(1) already exists. >> > You might try setting your sequences to be staggered (e.g., so that records inserted on db server 1 get odd-numbered values from the sequence,

Re: [Bucardo-general] ERROR: duplicate key value violates with master master replication

On Tue, May 13, 2014 at 11:13 PM, Juned Khan wrote: > Thanks for the answer, if i use this command to add all tables then > sequence will be added automatically for replication ? > >> bucardo add all tables db=master1 herd=mherd > > That command will only add *tables* to the things Bucardo knows