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

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

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
>