[Bucardo-general] Master-Slave Setup?
pheriko.support at gmail.com
Thu Oct 6 18:09:20 UTC 2016
Issues with ubuntu 14.x
For some reason the commando bucardo install tell me that the language
plperlu is not installed, but ubuntu say is already install.
INSTALLATION FAILED! (psql:/usr/share/bucardo/bucardo.schema:46:
ERROR: language "plperlu" does not exist
HINT: Use CREATE LANGUAGE to load the language into the database.)
apt-get install postgresql-plperl-9.3
Reading package lists... Done
Building dependency tree
Reading state information... Done
postgresql-plperl-9.3 is already the newest version.
0 upgraded, 0 newly installed, 0 to remove and 3 not upgraded.
On Tue, Oct 4, 2016 at 9:55 AM, Periko Support
<pheriko.support at gmail.com> wrote:
> 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.
>> David Christensen
>> End Point Corporation
>> david at endpoint.com
More information about the Bucardo-general