Re: [Bucardo-general] Master-Slave setup.

2016-10-17 Thread Periko Support
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 mas

Re: [Bucardo-general] Master-Slave setup.

2016-10-17 Thread David Christensen
> 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 yoursel

Re: [Bucardo-general] Master-Slave Setup?

2016-10-06 Thread Periko Support
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

Re: [Bucardo-general] Master-Slave Setup?

2016-10-06 Thread Greg Sabino Mullane
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...@

Re: [Bucardo-general] Master-Slave Setup?

2016-10-06 Thread Periko Support
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 alrea

Re: [Bucardo-general] Master-Slave Setup?

2016-10-06 Thread Greg Sabino Mullane
> 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 data

Re: [Bucardo-general] Master-Slave Setup?

2016-10-06 Thread Periko Support
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

Re: [Bucardo-general] Master-Slave Setup?

2016-10-04 Thread Periko Support
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'

Re: [Bucardo-general] Master-Slave Setup?

2016-10-04 Thread David Christensen
> 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 whic

Re: [Bucardo-general] Master-Slave Setup?

2016-10-04 Thread Periko Support
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 ha

Re: [Bucardo-general] Master-Slave Setup?

2016-10-04 Thread David Christensen
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 examp