Re: [GENERAL] Multi Master Replication setup

2016-03-28 Thread Pierre Chevalier
Hello, Searching BDR led me to a few surprising results... (trigrams definitely have numerous funny meanings ;o)) This URL will probably help: http://bdr-project.org/docs/stable/index.html Regards, Pierre Andreas Kretschmer a écrit : >Sachin Srivastava wrote: > >> Dear Concern, >> >> Kind

Re: [GENERAL] Multi Master Replication setup

2016-03-28 Thread Andreas Kretschmer
Sachin Srivastava wrote: > Dear Concern, > > Kindly inform to me how to setup multi master replication in Postgres. i think, you are looking for BDR. Please use google for more details. Regards, Andreas Kretschmer -- Andreas Kretschmer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7

[GENERAL] Multi Master Replication setup

2016-03-28 Thread Sachin Srivastava
Dear Concern, Kindly inform to me how to setup multi master replication in Postgres. Kindly provide the link of step by step setup of this or any video or setup document regarding this. Regards Sachin

Re: [GENERAL] Multi-master replication

2015-12-14 Thread Dmitry Mordovin
Just word of month, Thank you Simon for detailed explanation current status of BDR and PostgreSQL. BR, Dmitry On 12/14/2015 09:31 PM, Simon Riggs wrote: On 14 December 2015 at 15:55, Dmitry Mordovin > wrote: Hello All! As I heard, PostgreSQL 9.5 has bu

Re: [GENERAL] Multi-master replication

2015-12-14 Thread Simon Riggs
On 14 December 2015 at 15:55, Dmitry Mordovin wrote: > Hello All! > > As I heard, PostgreSQL 9.5 has built in Bi-Direction replication (or need > install BDR module?). > PostgreSQL 9.5 does not yet have the full code required for Bi-Directional replication. How did you hear that? Was that word o

Re: [GENERAL] Multi-master replication

2015-12-14 Thread Mario Soto Cordones
Dmitry Mordovin Enviado el: lunes, 14 de diciembre de 2015 13:45 Para: Merlin Moncure ; Andres Freund CC: PostgreSQL General Asunto: Re: [GENERAL] Multi-master replication Thank you Merlin, I see this doc too. But I confused, in 9.5 BDR placed to native code and becomes built in feature. So

Re: [GENERAL] Multi-master replication

2015-12-14 Thread Dmitry Mordovin
Thank you Merlin, I see this doc too. But I confused, in 9.5 BDR placed to native code and becomes built in feature. So, need I install external BDR or try to config built in version ? Or I didn't understood clearly. BR, Dmitry On 12/14/2015 08:38 PM, Merlin Moncure wrote: On Mon, Dec 1

Re: [GENERAL] Multi-master replication

2015-12-14 Thread Merlin Moncure
On Mon, Dec 14, 2015 at 9:55 AM, Dmitry Mordovin wrote: > Hello All! > > As I heard, PostgreSQL 9.5 has built in Bi-Direction replication (or need > install BDR module?). Huh -- that may be so. But if it is, it contradicts the BDR documentation: http://bdr-project.org/docs/stable/install-require

[GENERAL] Multi-master replication

2015-12-14 Thread Dmitry Mordovin
Hello All! As I heard, PostgreSQL 9.5 has built in Bi-Direction replication (or need install BDR module?). I wants to play with multi-master, asynchronous replication on two servers PostgreSQL 9.5 beta 2. In official docs very small information about how to configure servers. Could anyone

Re: [GENERAL] Multi Master Replication

2013-12-23 Thread Anand Kumar, Karthik
We use symmetricDS pretty extensively, across oracle and postgres databases. It has its flaws and its strengths. It shines when there's multiple database platforms involved, when the volume of transactions is not too high, and supports multi master. Its optimized for wan topologies, so its great if

Re: [GENERAL] Multi Master Replication

2013-12-23 Thread pax
Sometime ago i was looking for something like this and because at this time XC was a little baby i tried installing bucardo but i gave up when stucked fighting with perl modules. So, after testing some other solutions i decided to make my own, just "touching" the trigger part of the pyreplica proje

Re: [GENERAL] Multi Master Replication

2013-12-19 Thread John R Pierce
14 replies so far, and the OP hasn't chimed in with any feedback as to what their presumed requirements are based on. *meh* -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] Multi Master Replication

2013-12-19 Thread Michael Paquier
On Fri, Dec 20, 2013 at 8:48 AM, Michael Paquier wrote: > On Thu, Dec 19, 2013 at 11:18 PM, Chris Travers > wrote: >> >> >> >> On Thu, Dec 19, 2013 at 6:52 AM, Wolfgang Keller wrote: >>> >>> > 2. With sync replication, you have coordination problems and >>> > therefore it is never (at least IM

Re: [GENERAL] Multi Master Replication

2013-12-19 Thread Michael Paquier
On Thu, Dec 19, 2013 at 11:18 PM, Chris Travers wrote: > > > > On Thu, Dec 19, 2013 at 6:52 AM, Wolfgang Keller wrote: >> >> > 2. With sync replication, you have coordination problems and >> > therefore it is never (at least IME) a win compared to master-slave >> > replication since all writes m

Re: [GENERAL] Multi Master Replication

2013-12-19 Thread Chris Travers
On Thu, Dec 19, 2013 at 6:52 AM, Wolfgang Keller wrote: > > 2. With sync replication, you have coordination problems and > > therefore it is never (at least IME) a win compared to master-slave > > replication since all writes must occur in the same order in the set, > > or you need global sequen

Re: [GENERAL] Multi Master Replication

2013-12-19 Thread Wolfgang Keller
> 2. With sync replication, you have coordination problems and > therefore it is never (at least IME) a win compared to master-slave > replication since all writes must occur in the same order in the set, > or you need global sequences, or such. *snip* > You will never get better read or writ

Re: [GENERAL] Multi Master Replication

2013-12-18 Thread Chris Travers
On Wed, Dec 18, 2013 at 1:31 AM, itishree sukla wrote: > Hi all, > > I need suggestion about setting up multi master replication between two > postgresql server place two different geographical area. As i know using > some third party tool like Bucardo,RubyRep it can be achievable, not sue > which

Re: [GENERAL] Multi Master Replication

2013-12-18 Thread Michael Paquier
On Thu, Dec 19, 2013 at 2:05 PM, Scott Marlowe wrote: > Sharding with plproxy is pretty easy and can scale hugely. Yeah indeed, the writable postgres_fdw could also be used as a solution, if designed carefully. -- Michael -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To

Re: [GENERAL] Multi Master Replication

2013-12-18 Thread Scott Marlowe
On Wed, Dec 18, 2013 at 10:25 PM, Michael Paquier wrote: > On Thu, Dec 19, 2013 at 7:12 AM, Scott Marlowe > wrote: >> When people start talking multi-master replication my first response >> is to ask what problem you're trying to solve. Sometimes MM Rep IS the >> answer. But quite often it's n

Re: [GENERAL] Multi Master Replication

2013-12-18 Thread Michael Paquier
On Thu, Dec 19, 2013 at 7:12 AM, Scott Marlowe wrote: > On Wed, Dec 18, 2013 at 1:16 PM, John R Pierce wrote: >> that sort of replication is very problematic. its virtually impossible to >> maintain ACID (Atomicity, Consistency, Isolation, Durability) and maintain >> any semblance of performanc

Re: [GENERAL] Multi Master Replication

2013-12-18 Thread Scott Marlowe
On Wed, Dec 18, 2013 at 1:16 PM, John R Pierce wrote: > On 12/18/2013 1:31 AM, itishree sukla wrote: >> >> I need suggestion about setting up multi master replication between two >> postgresql server place two different geographical area. As i know using >> some third party tool like Bucardo,RubyR

Re: [GENERAL] Multi Master Replication

2013-12-18 Thread John R Pierce
On 12/18/2013 1:31 AM, itishree sukla wrote: I need suggestion about setting up multi master replication between two postgresql server place two different geographical area. As i know using some third party tool like Bucardo,RubyRep it can be achievable, not sue which is the good one to use. If

[GENERAL] Multi Master Replication

2013-12-18 Thread itishree sukla
Hi all, I need suggestion about setting up multi master replication between two postgresql server place two different geographical area. As i know using some third party tool like Bucardo,RubyRep it can be achievable, not sue which is the good one to use. If any one can provide me some online doc

Re: [GENERAL] multi-master replication (Was: Has Pg 9.1.0 been released today?)

2011-09-16 Thread Merlin Moncure
2011/9/16 Grzegorz Jaśkiewicz : > Is anyone actually working on Postgres-R ? Last git commit was in January > 2011. > What are the chances of it getting integrated with the core, which it > is probably targeted for ? > > If I picked it up, and tried to make usable for my own needs - instead > of i

Re: [GENERAL] multi-master replication (Was: Has Pg 9.1.0 been released today?)

2011-09-16 Thread Grzegorz Jaśkiewicz
Is anyone actually working on Postgres-R ? Last git commit was in January 2011. What are the chances of it getting integrated with the core, which it is probably targeted for ? If I picked it up, and tried to make usable for my own needs - instead of implementing trigger/log (slony like) multi mas

[GENERAL] multi-master replication (Was: Has Pg 9.1.0 been released today?)

2011-09-15 Thread Aleksey Tsalolikhin
On Tue, Sep 13, 2011 at 6:55 PM, Joshua D. Drake wrote: > >> On 09/13/2011 04:01 AM, Aleksey Tsalolikhin wrote: >>> >>> Now that you have streaming replication both async and sync, are you >>> working on multi-master replication? *excited* Or what's the >>> roadmap? > > I would take a look at post