Re: [Postgres-xc-general] Failed to get pooled connection error when any of node goes down

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

Hi koichi,

Yeah we can have slave of each component but in case of failure i need to
promote it
manually right ?

is there any way to make this process automatic ?




On Sat, Apr 5, 2014 at 7:49 AM, Koichi Suzuki <koi...@gm...> wrote:

> Each node can have its own slave.    Example configuration for
> pgxc_ctl will be found at
>
> http://sourceforge.net/apps/mediawiki/postgres-xc/index.php?title=PGOpen2013_Postgres_Open_2013
>
> You will also find example script of the demonstration I used at PG Open
> 2013.
>
> Regards;
> ---
> Koichi Suzuki
>
>
> 2014-04-04 20:12 GMT+09:00 Juned Khan <jkh...@gm...>:
> > Hi koichi,
> >
> > so it means if i have 10 clusters and if any of them goes down then whole
> > system will be useless
> >
> > what's the solution of this problem ? How to failover ?
> >
> >
> > On Fri, Apr 4, 2014 at 4:20 PM, 鈴木 幸市 <ko...@in...> wrote:
> >>
> >> Postgres-XC assumes all the nodes are running normally so that the
> planner
> >> can build a plan regarding clause push-down, table distribution and
> >> replication.
> >>
> >> The error indicates some of such nodes are down.
> >>
> >> Please restart the failed one and issue ‘select pgxc_pool_reload()’.
> >> ---
> >> Koichi Suzuki
> >>
> >> 2014/04/04 19:15、Juned Khan <jkh...@gm...> のメール：
> >>
> >> Hi all,
> >>
> >> I am using pgxc which has two datanodes (node1 and node2).
> >>
> >> As of now my application is connected to node1, yesterday due
> >> to some problem ssh service just stopped on second server.
> >>
> >> when i was trying to run any query on node1 then it gave  me
> >> "ERROR:  Failed to get pooled connection" .
> >>
> >> I was just wondering node2 is went down and my application is connected
> >> to node1 then why this problem? how does it relates to that error.
> >>
> >> is it normal ??
> >>
> >> Please suggest.
> >>
> >>
> >> --
> >> Thanks,
> >> Juned Khan
> >> iNextrix Technologies Pvt Ltd.
> >> www.inextrix.com
> >>
> >>
> ------------------------------------------------------------------------------
> >> _______________________________________________
> >> 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
> >
> >
> ------------------------------------------------------------------------------
> >
> > _______________________________________________
> > 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