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

[Juned K. <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