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

From Periko Support
Subject Re: [Bucardo-general] doubts about target db?
Date
Msg-id CAK2yrTZ2K5RzgxQ+4+HEP15CtZb_rC2VysfST3bpwOK6zMUmAw@mail.gmail.com
Whole thread Raw
Responses Re: [Bucardo-general] doubts about target db?  (Rakesh Kumar <rakeshkumar464@outlook.com>)
List 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.schwarz@gmail.com> wrote:
> On Thursday, October 13, 2016, Periko Support <pheriko.support@gmail.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


pgsql-general by date:

Previous
From: "FarjadFarid\(ChkNet\)"
Date:
Subject: Re: Multiple multithreaded insert
Next
From: Rakesh Kumar
Date:
Subject: Re: [Bucardo-general] doubts about target db?