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

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/

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 <mmonc...@gmail.com>; Andres Freund <and...@2ndquadrant.com> CC: PostgreSQL General <pgsql-general@postgresql.org> Asunto: Re: [GENERAL] Multi-master replication Thank you Merlin, I see t

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

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:

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

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

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

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

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 write

Re: [GENERAL] Multi Master Replication

2013-12-19 Thread Chris Travers
On Thu, Dec 19, 2013 at 6:52 AM, Wolfgang Keller felip...@gmx.net 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

Re: [GENERAL] Multi Master Replication

2013-12-19 Thread Michael Paquier
On Thu, Dec 19, 2013 at 11:18 PM, Chris Travers chris.trav...@gmail.com wrote: On Thu, Dec 19, 2013 at 6:52 AM, Wolfgang Keller felip...@gmx.net wrote: 2. With sync replication, you have coordination problems and therefore it is never (at least IME) a win compared to master-slave

Re: [GENERAL] Multi Master Replication

2013-12-19 Thread Michael Paquier
On Fri, Dec 20, 2013 at 8:48 AM, Michael Paquier michael.paqu...@gmail.com wrote: On Thu, Dec 19, 2013 at 11:18 PM, Chris Travers chris.trav...@gmail.com wrote: On Thu, Dec 19, 2013 at 6:52 AM, Wolfgang Keller felip...@gmx.net wrote: 2. With sync replication, you have coordination

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-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.

Re: [GENERAL] Multi Master Replication

2013-12-18 Thread Scott Marlowe
On Wed, Dec 18, 2013 at 1:16 PM, John R Pierce pie...@hogranch.com 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

Re: [GENERAL] Multi Master Replication

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

Re: [GENERAL] Multi Master Replication

2013-12-18 Thread Scott Marlowe
On Wed, Dec 18, 2013 at 10:25 PM, Michael Paquier michael.paqu...@gmail.com wrote: On Thu, Dec 19, 2013 at 7:12 AM, Scott Marlowe scott.marl...@gmail.com wrote: When people start talking multi-master replication my first response is to ask what problem you're trying to solve. Sometimes MM

Re: [GENERAL] Multi Master Replication

2013-12-18 Thread Michael Paquier
On Thu, Dec 19, 2013 at 2:05 PM, Scott Marlowe scott.marl...@gmail.com 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

Re: [GENERAL] Multi Master Replication

2013-12-18 Thread Chris Travers
On Wed, Dec 18, 2013 at 1:31 AM, itishree sukla itishree.su...@gmail.comwrote: 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

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

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 gryz...@gmail.com: 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 -