Re: Does Version 9.1 Streaming Replication Supports Multi-Master?

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(at)2ndquadrant(dot)com>:
> On Tue, Jan 17, 2012 at 6:33 PM, Fujii Masao <masao(dot)fujii(at)gmail(dot)com> wrote:
>> On Wed, Jan 18, 2012 at 3:09 AM, Jerry Richards
>> <jerry(dot)richards(at)teotech(dot)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
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general