Re: [Postgres-xc-general] How to stop promoted GTM slave after failover and bring back orginal

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

When you fail-over GTM, you should reconnect gym-proxies to the new
gtm.   This could have been done automatically but now you need to do
this annually using reconnect command of pgxc_ctl.   When you find gym
proxy is down, you can just restart it.

Regards;
---
Koichi Suzuki


2014-03-07 13:55 GMT+00:00 Juned Khan <jkh...@gm...>:
> Hi All,
>
> I have been configured pgxc with four servers.
>>
>> PGXC monitor all
>> Running: gtm master
>> Running: gtm slave
>> Running: gtm proxy gtm_pxy1
>> Running: gtm proxy gtm_pxy2
>> Running: coordinator master coord1
>> Running: coordinator master coord2
>> Running: datanode master datanode1
>> Running: datanode master datanode2
>
>
> I have configured slave for GTM, when i killed master GTM and promoted slave
> as master
> that's also worked fine.
>
> But i want to know what is exact procedure to bring original master to back
> using pgxc_ctl
>
> Even i tried with that manul process but still i am not able to bring it
> back. i think i messed up
> because now gtm proxies are fails to start
>
>> PGXC monitor all
>> Running: gtm master
>> Running: gtm proxy gtm_pxy1
>> Running: gtm proxy gtm_pxy2
>> Not running: coordinator master coord1
>> Not running: coordinator master coord2
>> Running: datanode master datanode1
>> Running: datanode master datanode2
>
>
> And still i don't see GTM slave running
> Can anyone please suggest me how to do this using pgxc_ctl?
>
>
> --
> Thanks,
> Juned Khan
> iNextrix Technologies Pvt Ltd.
> www.inextrix.com
>
> ------------------------------------------------------------------------------
> Subversion Kills Productivity. Get off Subversion & Make the Move to
> Perforce.
> With Perforce, you get hassle-free workflows. Merge that actually works.
> Faster operations. Version large binaries.  Built-in WAN optimization and
> the
> freedom to use Git, Perforce or both. Make the move to Perforce.
> http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>