From: | Periko Support <pheriko(dot)support(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: [Bucardo-general] doubts about target db? |
Date: | 2016-10-14 15:34:40 |
Message-ID: | CAK2yrTZ2K5RzgxQ+4+HEP15CtZb_rC2VysfST3bpwOK6zMUmAw@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks Rosser for your answer.
Other thing, with bucardo what is the difference between in a
master-master replica vs master-slave, at the end in both ways the
user has a 2nd DB with R/W permission?
Thanks.
On Thu, Oct 13, 2016 at 9:40 PM, Rosser Schwarz
<rosser(dot)schwarz(at)gmail(dot)com> wrote:
> On Thursday, October 13, 2016, Periko Support <pheriko(dot)support(at)gmail(dot)com>
> 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 master-master or master slave, bucardo is best to be reside in the
>> main master side?
>
>
> It doesn't really matter, as long as it can reach all the dbs it's
> managing. I've run it on the master, on the slave, and on another host
> entirely.
>
> rls
>
>
>
> --
> :wq
From | Date | Subject | |
---|---|---|---|
Next Message | Rakesh Kumar | 2016-10-14 15:54:56 | Re: [Bucardo-general] doubts about target db? |
Previous Message | FarjadFarid(ChkNet) | 2016-10-14 15:01:46 | Re: Multiple multithreaded insert |