Re: [Postgres-xc-developers] NEED same help

[Koichi S. <koi...@gm...>]

Hi,

In terms of GTM, you need gtm.control file of the master cluster to start
the slave cluster as another master.  For this purpose, you have two
options.

1. Configure GTM slave.  When you start slave cluster as a master,
configure coordinators/datanodes with GTM slave, or
2. Copy original GTM's gtm.control to the new GTM's working directory when
you start slave coordinators/datanodes as master.  You need to configure
these slaves with new GTM.

----------
Koichi Suzuki


2013/7/17 Ashutosh Bapat <ash...@en...>

> Hi Afonso,
> I am including the hackers mailing list for the best answer.
>
> AFAIU, you need to replicate your database between two Postgres-XC
> clusters? OR one Postgres-XC cluster and other PG instance? Is that right?
>
>
> You may
> 1. Setup 1 to 1 streaming replication between all the nodes of Postres-XC.
> I am not sure about GTM to GTM, but they may not be required. Right now
> there is no single channel streaming replication supported by XC, since the
> WALs are not available at central point.
>
> 2. Use trigger based replication between the two Postgres-XC instances.
> That might be costly.
>
>
> On Wed, Jul 17, 2013 at 4:23 PM, Afonso Bione <aag...@gm...> wrote:
>
>> Dear friend,
>>
>>     I installed Moodle using the master GTM and I  would like to
>> replicate the database on another machine using a Coordinator, but when I
>> create the database on another machine, I get an error message
>> could send me an example of how to use the postgresxc using the same
>> basis of the database on several computers with a GTM and Coordinator
>> .
>>          Thanks again
>>
>
>
>
> --
> Best Wishes,
> Ashutosh Bapat
> EntepriseDB Corporation
> The Postgres Database Company
>
>
> ------------------------------------------------------------------------------
> See everything from the browser to the database with AppDynamics
> Get end-to-end visibility with application monitoring from AppDynamics
> Isolate bottlenecks and diagnose root cause in seconds.
> Start your free trial of AppDynamics Pro today!
> http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>
>