Re: Geographical multi-master replication

2019-01-28 Thread Ruben Rubio Rey
> When I said “supported version” of BDR, I mostly meant a newer version of Postgres. I know you have to decide on getting support BDR but regardless of what route you take, part of your plan needs to be > 9.4 :). I agree with you. We will be upgrading to the latest postgres version. On Tue, Jan

Re: Geographical multi-master replication

2019-01-28 Thread Jeremy Finzel
On Mon, Jan 28, 2019 at 3:32 PM Ruben Rubio Rey wrote: > Hi Jeremy, > > > Why don't you consider upgrading from postgres 9.4 and with it to a > supported version of BDR? There is nothing better you can do to keep your > infrastructure up to date, performant, secure, and actually meet your > mult

Re: Geographical multi-master replication

2019-01-28 Thread Ruben Rubio Rey
Hi Jeremy, > Why don't you consider upgrading from postgres 9.4 and with it to a supported version of BDR? There is nothing better you can do to keep your infrastructure up to date, performant, secure, and actually meet your multi-master needs than to upgrade to a newer version of postgres which

Re: Sv: Re: Geographical multi-master replication

2019-01-25 Thread Andrew Smith
On Fri., 25 Jan. 2019, 8:40 pm Andreas Kretschmer > > Am 25.01.19 um 10:10 schrieb Andreas Joseph Krogh: > > To my surprise I'm unable to find downloadable BDR3. I thought it was > > an open-source extention to vanilla-pg-11, isn't that the case anymore? > > yeah, you have to sign a support contra

Re: Sv: Re: Geographical multi-master replication

2019-01-25 Thread Andreas Kretschmer
Am 25.01.19 um 10:10 schrieb Andreas Joseph Krogh: To my surprise I'm unable to find downloadable BDR3. I thought it was an open-source extention to vanilla-pg-11, isn't that the case anymore? yeah, you have to sign a support contract. It works as a extension to vanilla-pg-11, but it's not

Sv: Re: Geographical multi-master replication

2019-01-25 Thread Andreas Joseph Krogh
På fredag 25. januar 2019 kl. 06:45:43, skrev Andreas Kretschmer < andr...@a-kretschmer.de >: Am 25.01.19 um 06:10 schrieb Jeremy Finzel: > >     The problem is that the version for BDR 1.0.7, which has an >     implementation for postgres 9.4, will be on end o

Re: [External] Re: Geographical multi-master replication

2019-01-24 Thread Vijaykumar Jain
I do not know the use case but we did try the following. We had a small requirement wrt some regional data written to tables but needs to be available to all regions. We made use of logical replication to replicate/publish each local table to all the other regions ( like a many to many) In theory,

Re: Geographical multi-master replication

2019-01-24 Thread Andreas Kretschmer
Am 25.01.19 um 06:10 schrieb Jeremy Finzel: The problem is that the version for BDR 1.0.7, which has an implementation for postgres 9.4, will be on end of live at the end of this year. Unfortunately the paid solution is out of our budget, so we currently have two options: find

Re: Geographical multi-master replication

2019-01-24 Thread Jeremy Finzel
> > The problem is that the version for BDR 1.0.7, which has an implementation > for postgres 9.4, will be on end of live at the end of this year. > Unfortunately the paid solution is out of our budget, so we currently have > two options: find an alternative or remove the multi-region implementatio

Geographical multi-master replication

2019-01-24 Thread Ruben Rubio Rey
Hi Everybody, I am currently working with a client that has requirements for geographically dispersed multi-master replication. The current solution that we have in place is the BDR 1.0.7, which is asynchronous and eventually consistent and it is actually very close to real time. So far we are ma