Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxxxx>:
> On Tue, Jan 17, 2012 at 6:33 PM, Fujii Masao <masao.fujii@xxxxxxxxx> wrote:
>> On Wed, Jan 18, 2012 at 3:09 AM, Jerry Richards
>> <jerry.richards@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux