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

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

Responses

Browse pgsql-general by date

  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