[Bucardo-general] Master-Slave Setup?

Periko Support pheriko.support at gmail.com
Tue Oct 4 16:55:05 UTC 2016


This week I will tested and return with questions. thanks david!!!

On Tue, Oct 4, 2016 at 8:39 AM, David Christensen <david at endpoint.com> wrote:
>
>> On Oct 4, 2016, at 10:20 AM, Periko Support <pheriko.support at gmail.com> wrote:
>>
>> Yes, I already did psql replica master-slave, works but our pentaho
>> implementation with in OPENERP don't allow us to run openerp+pentaho
>> in the slave.
>>
>> This setup require read/write to the database and the slave is
>> read-only which our reports fail.
>>
>> This is why we need something that allow us to have a copy of our psql
>> read/write mode and some one told us about bucardo.
>>
>> This can help to fix our issue right?
>>
>> Thanks for your help and time.
>
> Yup, if you need a writeable database cluster you need to use a logical replication system like Bucardo.
>
> The main difference between the master-master examples and normal master-slave would be that when defining the sync instead of having `bucardo add sync foo dbs=source:dbA,source:dbB,source:dbC` you just need to provide the list of the individual databases.  Bucardo assumes (unless otherwise told) that the databases are given in the order of source, target, target, […].
>
> So you’d be looking at `bucardo add sync foo dbs=dbA,dbB,dbC` to setup a sync from dbA to dbB and dbC.
>
> HTH,
>
> David
> --
> David Christensen
> End Point Corporation
> david at endpoint.com
> 785-727-1171
>
>
>


More information about the Bucardo-general mailing list