Re: [GENERAL] Master-master replication with PostgreSQL

2008-04-17 Thread Rob Collins
Thanks everyone for your very helpful comments. I'm setting up some spikes to check performance and functionality of various alternatives. Rob On 16/04/2008, Greg Smith <[EMAIL PROTECTED]> wrote: > > On Wed, 16 Apr 2008, Rob Collins wrote: > > My client has a flawed MS SQL Server system > > > >

Re: [GENERAL] Master-master replication with PostgreSQL

2008-04-16 Thread Greg Smith
On Wed, 16 Apr 2008, Rob Collins wrote: My client has a flawed MS SQL Server system There's another kind? From what I've read, Slony-I does only master-slave replication and Slony-II is not being actively developed. Is this right? Are there any viable master-master replication tools for Pos

Re: [GENERAL] Master-master replication with PostgreSQL

2008-04-16 Thread Rodrigo Gonzalez
Yes, basically there is something that is not theremakedelta is what allow me to do thatI took that information from bucardo mailing list But the important thing is that is possible and maybe one day will be a true grid multimaster replication systemright now I didnt find anyth

Re: [GENERAL] Master-master replication with PostgreSQL

2008-04-16 Thread Alvaro Herrera
Rodrigo Gonzalez escribió: > Yes and no > > bucardo cannot handle master-master-master > > What I am doing is > > masterA-masterB > masterA-masterC > masterA-masterD Oh, I see -- makes sense. Quite misleading docs, then. -- Alvaro Herrerahttp://www.CommandPro

Re: [GENERAL] Master-master replication with PostgreSQL

2008-04-16 Thread Rodrigo Gonzalez
Yes and no bucardo cannot handle master-master-master What I am doing is masterA-masterB masterA-masterC masterA-masterD That is something that bucardo can handle and allow me to replicate masterB-masterC but everything goes thru masterA always Alvaro Herrera escribió: Rodrigo Gonzalez

Re: [GENERAL] Master-master replication with PostgreSQL

2008-04-16 Thread Alvaro Herrera
Rodrigo Gonzalez escribió: > Using star replication I have all the nodes as masterso n > master-master replication with the common DB as master to all the nodes > and all the nodes as master to the common DB Oh, so the Bucardo docs are incorrect. http://www.bucardo.org/bucardo.html#Bucard

Re: [GENERAL] Master-master replication with PostgreSQL

2008-04-16 Thread Rodrigo Gonzalez
Using star replication I have all the nodes as masterso n master-master replication with the common DB as master to all the nodes and all the nodes as master to the common DB Alvaro Herrera escribió: Julio Cesar Sánchez González wrote: El mié, 16-04-2008 a las 12:13 +0100, Rob Collins

Re: [GENERAL] Master-master replication with PostgreSQL

2008-04-16 Thread Greg Sabino Mullane
-BEGIN PGP SIGNED MESSAGE- Hash: RIPEMD160 >> Try with bucardo ("http://bucardo.org/";) may be help you :). > Doesn't bucardo handle conflicts with "whichever one I apply last > wins"? That doesn't seem safe in all situations (or any, IMO). With Bucardo, conflict handling is chosen as

Re: [GENERAL] Master-master replication with PostgreSQL

2008-04-16 Thread Dragan Zubac
Hello http://www.postgresql.at/english/pr_cybercluster_e.html didn't test it myself though Sincerely Dragan Rob Collins wrote: Hello Dimitri To clarify the requirement: much like you, we're not looking for synchronous replication, which would be too slow. The branches and central server c

Re: [GENERAL] Master-master replication with PostgreSQL

2008-04-16 Thread Dimitri Fontaine
Hi, Le mercredi 16 avril 2008, Rob Collins a écrit : > To clarify the requirement: much like you, we're not looking for > synchronous replication, which would be too slow. The branches and central > server can be different for about 5 to 10 minutes. But the branches need to > be able to function i

Re: [GENERAL] Master-master replication with PostgreSQL

2008-04-16 Thread Erik Jones
On Apr 16, 2008, at 8:44 AM, Rob Collins wrote: Hello Dimitri To clarify the requirement: much like you, we're not looking for synchronous replication, which would be too slow. The branches and central server can be different for about 5 to 10 minutes. But the branches need to be able to

Re: [GENERAL] Master-master replication with PostgreSQL

2008-04-16 Thread Alvaro Herrera
Julio Cesar Sánchez González wrote: > > El mié, 16-04-2008 a las 12:13 +0100, Rob Collins escribió: > > We're looking for an open-source database solution that has a Python > > interface and will do master-master replication. My client has a > > flawed MS SQL Server system, with the replication h

Re: [GENERAL] Master-master replication with PostgreSQL

2008-04-16 Thread Vivek Khera
On Apr 16, 2008, at 8:47 AM, Julio Cesar Sánchez González wrote: From what I've read, Slony-I does only master-slave replication and Slony-II is not being actively developed. Is this right? Are there any viable master-master replication tools for PostgreSQL. (They could be commercial/paid for

Re: [GENERAL] Master-master replication with PostgreSQL

2008-04-16 Thread Rob Collins
Hello Dimitri To clarify the requirement: much like you, we're not looking for synchronous replication, which would be too slow. The branches and central server can be different for about 5 to 10 minutes. But the branches need to be able to function independently if the network or central goes dow

Re: [GENERAL] Master-master replication with PostgreSQL

2008-04-16 Thread Rodrigo Gonzalez
Rob Collins escribió: Hello We're looking for an open-source database solution that has a Python interface and will do master-master replication. My client has a flawed MS SQL Server system, with the replication hand-coded in Python. They don't want to pay very high licence fees for the MS SQ

Re: [GENERAL] Master-master replication with PostgreSQL

2008-04-16 Thread Dimitri Fontaine
Hi, Le mercredi 16 avril 2008, Rob Collins a écrit : > There is one central server with 19 branches. Some tables need to replicate > from the central server to the branches. Other tables are centralised from > the branches into one totalling table at the centre. A few tables need to > replicate in

Re: [GENERAL] Master-master replication with PostgreSQL

2008-04-16 Thread Julio Cesar Sánchez González
El mié, 16-04-2008 a las 12:13 +0100, Rob Collins escribió: > Hello > > We're looking for an open-source database solution that has a Python > interface and will do master-master replication. My client has a > flawed MS SQL Server system, with the replication hand-coded in > Python. They don't wa

[GENERAL] Master-master replication with PostgreSQL

2008-04-16 Thread Rob Collins
Hello We're looking for an open-source database solution that has a Python interface and will do master-master replication. My client has a flawed MS SQL Server system, with the replication hand-coded in Python. They don't want to pay very high licence fees for the MS SQL Server Enterprise version