3 ms·
Improved, yes. Fixed, no. Basically if you want proper full replication, you won't get it out of the box, but will have to use various third party tools. Tha
by dagw 11y ago
Improved, yes. Fixed, no. Basically if you want proper full replication, you won't get it out of the box, but will have to use various third party tools. That being said 9.4 added a bunch of the fundamental changes that that laid the foundation for full replication, now we're just waiting PG to finish exposing those features with userland tools.
- amatix 11y agoBuilt-in multi-master replication is the only real missing piece there, AFAIK every other replication base is covered well natively. Besides that, sync & async replication has been there nicely since 9.2. 9.3 added timeline switches, needed for cascaded slave setups in practice. 9.4 added replication slots so the master can keep track of slave sync status, and the foundations for multi-master & logical replication. 9.5 added pg_rewind which speeds up resyncs.
- DrJokepu 11y agoWhat do you mean by "proper full replication"?
- barrkel 11y agoMaster-master
- rgacote 11y agoThe EnterpriseDB folk http://www.enterprisedb.com/products-services-training/products-overview/xdb-replication-server-multi-master http://www.enterprisedb.com/products-services-training/produ... and 2ndQuadrant http://2ndquadrant.com/en-us/resources/bdr/ http://2ndquadrant.com/en-us/resources/bdr/ both have multi-master replication.