From: | Koichi Suzuki <koichi(dot)szk(at)gmail(dot)com> |
---|---|
To: | Simon Riggs <simon(at)2ndquadrant(dot)com> |
Cc: | Fujii Masao <masao(dot)fujii(at)gmail(dot)com>, Jerry Richards <jerry(dot)richards(at)teotech(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Does Version 9.1 Streaming Replication Supports Multi-Master? |
Date: | 2012-01-19 05:11:29 |
Message-ID: | CAAn2te_web_Dgz83Rz_Z9wA0DqPMLiQ-F0SKJqGWuLMkCOUiow@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Volodymyr Kostyrko | 2012-01-19 08:53:47 | Re: scenario with a slow query |
Previous Message | Simon Riggs | 2012-01-18 23:06:21 | Re: Does Version 9.1 Streaming Replication Supports Multi-Master? |