3 ms·
Postgres has had solid replication since 8.4
by dickeytk 14y ago
Postgres has had solid replication since 8.4
- mhurron 14y agoIt doesn't do two way, you have to go to 3rd party addons for that.
- sciurus 14y agoIt was only in Postgres 9.0, released in Septermber 2010, that support for a "hot standby" (e.g. master/slave replication where you can run read-only queries on the slave) was added. MySQL has supported this since at least version 3.2.3, released in January 2001. MySQL supports • Single master to one slave • Single master to multiple slaves • Single master to one slave to one or more slaves • Circular replication (A to B to C and back to A) • Master to master Postgres supports • Single master to one slave • Single master to multiple slaves (lists from http://www.theserverside.com/feature/Comparing-MySQL-and-Postgres-90-Replication http://www.theserverside.com/feature/Comparing-MySQL-and-Pos...)