Re: [Postgres-xc-general] Postgres-XC - GTM HA

[Bruno C. O. <bru...@ho...>]

Hi Koichi Suzuki,

i'm using the pgxc_ctl but how the gtm-proxy can commute to gtm standby
automatic, without a manual intervention?
Whem the gtm-proxy have a timeout more then 5 seconds, for exemple, the
gtm-proxy commute automatically to the gtm standby.

The gtm-proxy can do this? Or i need to create a script to do this?


Thanks for the answer!


2014-06-16 21:47 GMT-03:00 鈴木 幸市 <ko...@in...>:

>  pgxc_ctl provides automated process for this.   You have to configure XC
> cluster with pgxc_ctl though.   In this case, although, you need to promote
> GTM standby and reconnect gtm_proxy with separate pgxc_ctl command.
>
>  pgxc_ctl source material is under contrib directory.    Reference and
> tutorial are available at
> http://postgres-xc.sourceforge.net/docs/1_2_1/pgxc-ctl.html and
> https://sourceforge.net/projects/postgres-xc/files/Pgxc_ctl_primer/
> respectively.
>
>  Regards;
> ---
> Koichi Suzuki
>
>  2014/06/17 3:52、Bruno Cezar Oliveira <bru...@ho...> のメール：
>
>  Hi!
>
> I'm using this tutorial to simulate a HA environment with Postgres-xc.
> http://postgresxc.wikia.com/wiki/GTM_Standby_Configuration
>
> I did the gtm down and gtm-standby going up.
> The problem is that is a manual process, i had to run a command in all
> gtm-proxy and gtm standby.
> How i can make this process automatic?
>
> Thank you!
>
> --
> Att,
> Bruno Cezar de Oliveira.
> bru...@ho...
> -------------------------------------------------------
> Uberlândia - MG.
>
> ------------------------------------------------------------------------------
> HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
> Find What Matters Most in Your Big Data with HPCC Systems
> Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
> Leverages Graph Analysis for Fast Processing & Easy Data Exploration
>
> http://p.sf.net/sfu/hpccsystems_______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>
>
>


-- 
Att,
Bruno Cezar de Oliveira.
bru...@ho...
-------------------------------------------------------
Uberlândia - MG.