3 ms·

With 9.4, what will be the best option for multi-master replication? Will 3rd party tools like bucardo remain the preferred method, or will there be another st

by andyl 12y ago

With 9.4, what will be the best option for multi-master replication? Will 3rd party tools like bucardo remain the preferred method, or will there be another strategy that is more integrated with PG?

rpedela 12y ago
My understanding is you still need the 3rd party tools. The new replication features lay the foundation for other replication strategies like multi-master, but they are not implemented yet.
rdtsc 12y ago
In general on the CAP spectrum where does multi-master replication with Postgres fall in?
- gatehouse 12y ago
  CP, ~A, AFAIK
- DrJokepu 12y ago
  Replication in PostgreSQL is actually highly configurable so it depends on how you set it up: http://www.postgresql.org/docs/9.3/static/high-availability.html http://www.postgresql.org/docs/9.3/static/high-availability....
jeffdavis 12y ago
The logical decoding feature is a very important foundation that will help multi-master solutions. No multi-master out-of-the-box today though. EDIT: logical decoding allows you to get access to a stream of logical data changes, e.g. inserts, updates, deletes, in a robust and efficient way.