Обсуждение: Does Version 9.1 Streaming Replication Supports Multi-Master?
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
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>: > 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 > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general