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

[Juned K. <jkh...@gm...>]

Hi Koichi,

Yeah failover GTM and reconnection to GTM proxies to new GTM just works fine
but how to reconnect to master GTM when it comes up ?


On Sat, Mar 8, 2014 at 8:24 PM, Koichi Suzuki <koi...@gm...> wrote:

> 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
> >
>



-- 
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com