Re:PostgreSQL 9.4 Beta 1 Released
by andyl on Thursday May 15, 2014 @11:11AM
(#7749872)
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?
[ Parent
| on HN ]
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.
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.
In general on the CAP spectrum where does multi-master replication with Postgres fall in?
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....