Re: [Bucardo-general] Master-Slave setup.
Excellent David, them I will do that first, them add pushdelta to my sync and continue testing. Thanks. On Mon, Oct 17, 2016 at 10:04 AM, David Christensen wrote: >> This week will continue testing but I have some doubts in a Master-Slave >> Setup. >> >> The slave db, if I will replicate the master, is prefer to start my >> slave with empty data? or with a exact copy of my master db? > > Hi Periko, > > If you can start it with a copy of the master db you save yourself a step. > Otherwise you will need to initialize the target in Bucardo either using a > onetimesync=1 in the sync definition or copy over using pg_dump out-of-band. > Bucardo will not load the data in the target explicitly without being told > to, so if you just started with empty data it would only copy the rows over > as changes were made to them, probably not the effect you were looking for. > > David > -- > David Christensen > End Point Corporation > da...@endpoint.com > 785-727-1171 > > > ___ Bucardo-general mailing list Bucardo-general@bucardo.org https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Re: [Bucardo-general] Master-Slave setup.
> This week will continue testing but I have some doubts in a Master-Slave > Setup. > > The slave db, if I will replicate the master, is prefer to start my > slave with empty data? or with a exact copy of my master db? Hi Periko, If you can start it with a copy of the master db you save yourself a step. Otherwise you will need to initialize the target in Bucardo either using a onetimesync=1 in the sync definition or copy over using pg_dump out-of-band. Bucardo will not load the data in the target explicitly without being told to, so if you just started with empty data it would only copy the rows over as changes were made to them, probably not the effect you were looking for. David -- David Christensen End Point Corporation da...@endpoint.com 785-727-1171 ___ Bucardo-general mailing list Bucardo-general@bucardo.org https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Re: [Bucardo-general] Master-Slave Setup?
Good, I already finish the setup, I'm working with the test db, thanks for your help guys!!! On Thu, Oct 6, 2016 at 12:53 PM, Greg Sabino Mullane wrote: > On Thu, Oct 06, 2016 at 12:33:49PM -0700, Periko Support wrote: >> Bucardo user inside postgresql DB must be superuser? >> Or this step can be done with postgres main user? >> thanks. > > Yes, bucardo user must be a superuser, but either can be > used to create the language. > > -- > Greg Sabino Mullane g...@endpoint.com > End Point Corporation > PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 > ___ Bucardo-general mailing list Bucardo-general@bucardo.org https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Re: [Bucardo-general] Master-Slave Setup?
On Thu, Oct 06, 2016 at 12:33:49PM -0700, Periko Support wrote: > Bucardo user inside postgresql DB must be superuser? > Or this step can be done with postgres main user? > thanks. Yes, bucardo user must be a superuser, but either can be used to create the language. -- Greg Sabino Mullane g...@endpoint.com End Point Corporation PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 signature.asc Description: PGP signature ___ Bucardo-general mailing list Bucardo-general@bucardo.org https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Re: [Bucardo-general] Master-Slave Setup?
Bucardo user inside postgresql DB must be superuser? Or this step can be done with postgres main user? thanks. On Thu, Oct 6, 2016 at 12:18 PM, Greg Sabino Mullane wrote: >> For some reason the commando bucardo install tell me that the language >> plperlu is not installed, but ubuntu say is already install. > > Putting a language into a database requires two steps: having > it compiled into Postgres (the apt-get call in this case) and then > loading it into individual databases via CREATE LANGAGE. There > may be other reasons why CREATE LANGUAGE fails, but that's the first > thing to debug by trying: > > psql -U bucardo bucardo -c 'create language plperlu' > > -- > Greg Sabino Mullane g...@endpoint.com > End Point Corporation > PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 ___ Bucardo-general mailing list Bucardo-general@bucardo.org https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Re: [Bucardo-general] Master-Slave Setup?
> For some reason the commando bucardo install tell me that the language > plperlu is not installed, but ubuntu say is already install. Putting a language into a database requires two steps: having it compiled into Postgres (the apt-get call in this case) and then loading it into individual databases via CREATE LANGAGE. There may be other reasons why CREATE LANGUAGE fails, but that's the first thing to debug by trying: psql -U bucardo bucardo -c 'create language plperlu' -- Greg Sabino Mullane g...@endpoint.com End Point Corporation PGP Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 signature.asc Description: PGP signature ___ Bucardo-general mailing list Bucardo-general@bucardo.org https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Re: [Bucardo-general] Master-Slave Setup?
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. Ubuntu issue...? On Tue, Oct 4, 2016 at 9:55 AM, Periko Support wrote: > This week I will tested and return with questions. thanks david!!! > > On Tue, Oct 4, 2016 at 8:39 AM, David Christensen wrote: >> >>> On Oct 4, 2016, at 10:20 AM, Periko Support >>> 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 >> da...@endpoint.com >> 785-727-1171 >> >> >> ___ Bucardo-general mailing list Bucardo-general@bucardo.org https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Re: [Bucardo-general] Master-Slave Setup?
This week I will tested and return with questions. thanks david!!! On Tue, Oct 4, 2016 at 8:39 AM, David Christensen wrote: > >> On Oct 4, 2016, at 10:20 AM, Periko Support >> 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 > da...@endpoint.com > 785-727-1171 > > > ___ Bucardo-general mailing list Bucardo-general@bucardo.org https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Re: [Bucardo-general] Master-Slave Setup?
> On Oct 4, 2016, at 10:20 AM, Periko Support 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 da...@endpoint.com 785-727-1171 ___ Bucardo-general mailing list Bucardo-general@bucardo.org https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Re: [Bucardo-general] Master-Slave Setup?
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. On Tue, Oct 4, 2016 at 7:44 AM, David Christensen wrote: > Hi Periko, > > While Bucardo does support Master/Slave replication, PostgreSQL’s native > replication supports this quite nicely out-of-the-box. Not to discourage you > from Bucardo for this purpose, but you’ve verified this wouldn’t be > sufficient for your needs? > > If you’re looking for a Bucardo example, you can start with > https://bucardo.org/wiki/Bucardo/pgbench_example . It’s not completely > up-to-date; it’s written for the older Bucardo 4, but substituting > “bucardo_ctl” with “bucardo” might get you most of the way there. > > Best, > > David > -- > David Christensen > End Point Corporation > da...@endpoint.com > 785-727-1171 > > > ___ Bucardo-general mailing list Bucardo-general@bucardo.org https://mail.endcrypt.com/mailman/listinfo/bucardo-general
Re: [Bucardo-general] Master-Slave Setup?
Hi Periko, While Bucardo does support Master/Slave replication, PostgreSQL’s native replication supports this quite nicely out-of-the-box. Not to discourage you from Bucardo for this purpose, but you’ve verified this wouldn’t be sufficient for your needs? If you’re looking for a Bucardo example, you can start with https://bucardo.org/wiki/Bucardo/pgbench_example . It’s not completely up-to-date; it’s written for the older Bucardo 4, but substituting “bucardo_ctl” with “bucardo” might get you most of the way there. Best, David -- David Christensen End Point Corporation da...@endpoint.com 785-727-1171 ___ Bucardo-general mailing list Bucardo-general@bucardo.org https://mail.endcrypt.com/mailman/listinfo/bucardo-general