Does Version 9.1 Streaming Replication Supports Multi-Master?

On Wed, Jan 18, 2012 at 3:09 AM, Jerry Richards
<jerry.richards@teotech.com> 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?

Only a single-master. If you want a multi-master solution, see Postgres-XC.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

Only a single-master. If you want a multi-master solution, see Postgres-XC.

Is postgres XC production ready? Can I trust my most valuable data to it?

Cheers.

On Tue, Jan 17, 2012 at 1:25 PM, Tim Uckun <timuckun@gmail.com> wrote:

Only a single-master. If you want a multi-master solution, see Postgres-XC.

Is postgres XC production ready? Can I trust my most valuable data to it?

The only way to know is to test it yourself. But at least a sales rep
from "Big Database Company Inc" won't lie to you to get the sale in
this case.

On Tue, Jan 17, 2012 at 6:33 PM, Fujii Masao <masao.fujii@gmail.com> wrote:

On Wed, Jan 18, 2012 at 3:09 AM, Jerry Richards
<jerry.richards@teotech.com> 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?

Only a single-master. If you want a multi-master solution, see Postgres-XC.

Postgres-XC doesn't support multi-site disaster recovery.

Oracle RAC recommends the use of Data Guard as well. Does Postgres-XC
support streaming replication for replay on another Postgres-XC
cluster? If so, you have been a busy bee.

--
 Simon Riggs                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Yes it does, not for hot standby though. Each node can have streaming
replication slave for recovery. Also, GTM has its own
backup/recovery mechanism which provide no-loss failover when GTM
fails.

Regards;
----------
Koichi Suzuki

# For XC to provide hot standby feature, we need to synchronize the
visibility of each node, which is not implemented yet. For recovery,
XC provides a feature to synchronize recovery point of each node.

2012/1/19 Simon Riggs <simon@2ndquadrant.com>: