Does Version 9.1 Streaming Replication Supports Multi-Master?

Started by Jerry Richardsabout 14 years ago2 messagesgeneral
Jump to latest
#1Jerry Richards
jerry.richards@teotech.com

I know PostgreSQL version 9.1 supports built-in streaming replication. Just wondering if that supports only a single-master or also multi-master implementation?

Thanks,
Jerry

________________________________
Sample disclaimer text

#2John R Pierce
pierce@hogranch.com
In reply to: Jerry Richards (#1)
Re: Does Version 9.1 Streaming Replication Supports Multi-Master?

On 01/17/12 12:10 PM, Jerry Richards wrote:

I know PostgreSQL version 9.1 supports built-in streaming
replication. Just wondering if that supports only a single-master or
also multi-master implementation?

master -> readonly slave only.

Master-Master replication is a giant can of worms, with thorny issues of
conflict resolution that can't be resolved in a general case without
massive performance impacts.

--
john r pierce N 37, W 122
santa cruz ca mid-left coast