PostgreSQL with master -> multiple slaves. What to use?
Posted on 2007-11-24
We're looking to move our DBMS to PostgreSQL, and I'm looking for a good reliable replication system to use.
The idea is this; a master and slave onsite and then another slave at our second premises down a 10Mb line.
I've looked about and seen mnay different projects about to do this, and I could do with a bit of advice. Has anyone done this, and how good is it?
From what I see slony or pgreplicator do this.
Having tried the innodb replication built into MySQL something similar would be ace. The only reason we're not going with MySQL is I seem to be told everywhere that it's not as fault tollerent as Postgres, however nobody has given me an explanation why.