Re: [Postgres-xc-general] Problem wtih GTM Stand By configuration

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

If you mean master-master just replication, you should specify each
table as DISTRIBUTE BY REPLICATION.

Adding servers could be complicated steps.   I advice to use pgxc_ctl
to configure and maintain your cluster.    You will find the document
at http://postgres-xc.sourceforge.net/docs/1_1/pgxc-ctl.html

When you add new server, you can add new
datanode/coordinator/gtm_proxy with pgxc_ctl commands.    Also, you
can redistribute your table (in this case, add a node to replicate the
data), you can use ALTER TABLE.   Document will be at
http://postgres-xc.sourceforge.net/docs/1_1/sql-altertable.html

XC is not intended to use as multimaster replication.    It assumes
that you have a few big tables updated very frequently (transaction
tables) which should be distributed, not replicated and other tables
which are relatively stable and are joined frequently with transaction
tables (master tables).

Regards;
---
Koichi Suzuki


2014-02-17 15:51 GMT+09:00 Juned Khan <jkh...@gm...>:
> Hi All,
>
> I want to use postgre-xc for multi master uses. I want to setup two server
> with GTM,cordinator and datanodes.
>
> And in future i want to add another servers as well with same configuration,
> and in future i will add more.
>
> To test this, i have setup two server with GTM,Coordinator and datanode on
> same server. i have follow below link for configuration.
>
> http://postgresxc.wikia.com/wiki/Laptop_configuration
>
> Now How do i configuration this two system as master master configuration,
> will add more masters in future.
>
> I found link of GTM standby configuration,then i have setup GTM standby on
> one separate system using below link.
>
> http://postgresxc.wikia.com/wiki/GTM_Standby_Configuration
>
> then i started GTM, datanodes and ordinators on both server, then i tried to
> run below command on Stand By  server.
>
> gtm_ctl promote -Z gtm -D /home/postgresxc/pgxc/gtm/ -o "-s gtm -t 20001"
>
> But got this error:
> gtm_ctl: could not send promote signal (PID: 11937): No such process
>
> So my question is am i going to right way to achieve my goal ? how do i
> avoid this error ?
>
>
> --
> Thanks,
> Juned Khan
> iNextrix Technologies Pvt Ltd.
> www.inextrix.com
>
> ------------------------------------------------------------------------------
> Android apps run on BlackBerry 10
> Introducing the new BlackBerry 10.2.1 Runtime for Android apps.
> Now with support for Jelly Bean, Bluetooth, Mapview and more.
> Get your Android app in front of a whole new audience.  Start now.
> http://pubads.g.doubleclick.net/gampad/clk?id=124407151&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>