[web2py] Re: PostgreSQL replication

2010-11-13 Thread ron_m
SymmetricDS looks like the best alternative so far for the application I am working on. The application they developed for is a close match to the kind of data sync I need. Thanks for the link to the article. I will run a test implementation. On Nov 11, 11:56 pm, shem p she...@gmail.com wrote:

Re: [web2py] Re: PostgreSQL replication

2010-11-12 Thread Michele Comitini
This is probably what you need. What scared me away is that it is a query based system, there are some potential drawbacks depending on the type of query, but you have advantages too, such as extreme parallel execution, so I suggest to take a look! http://wiki.postgresql.org/wiki/Pgpool-II mic

[web2py] Re: PostgreSQL replication

2010-11-12 Thread shem p
Maybe any of this would help: http://www.haroonidrees.com/2009/04/open-sour.html On Nov 12, 2:07 pm, ron_m ron.mco...@gmail.com wrote: Thanks for the pointers from both of you, I appreciate that. It would be best to have multiple master but that will be very difficult. Bucardo has multiple

[web2py] Re: PostgreSQL replication

2010-11-11 Thread mdipierro
Hi Ron, I do not much about this topic. Will single master be enough? You may want to look into these tools as well. http://www.slony.info/ http://www.sistemasagiles.com.ar/trac/wiki/PyReplicaEn https://public.commandprompt.com/projects/replicator On Nov 11, 1:51 pm, ron_m

Re: [web2py] Re: PostgreSQL replication

2010-11-11 Thread Michele Comitini
There are some good news for postgresql 9.0: http://www.postgresql.org/docs/9.0/interactive/warm-standby.html some of those features above are possible on 8.4 with some difficult configuration tricks, see wiki.postgresql.org. mic 2010/11/11 mdipierro mdipie...@cs.depaul.edu: Hi Ron, I do

[web2py] Re: PostgreSQL replication

2010-11-11 Thread ron_m
Thanks for the pointers from both of you, I appreciate that. It would be best to have multiple master but that will be very difficult. Bucardo has multiple master but only for 2 masters once you get into the docs for it. The MySQL scheme I mentioned used primary key skipping on autonumbers so if