Re: [Postgres-xc-developers] Installation Guide

[West, W. <ww...@uc...>]

All,

I was successful in finally configuring my 2 node cluster properly and it
is communicating on all nodes. Thanks for all the help especially from
Michael. Please feel free to close this ticket.

Regards,

bw

On 8/20/13 8:28 PM, "West, William" <ww...@uc...> wrote:

>Will do in the future.
>
>Thanks,
>
>bw
>
>On 8/20/13 7:56 PM, "West, William" <ww...@uc...> wrote:
>
>>Michael,
>>
>>Here are the results of the two queries:
>>
>>postgres=# execute direct on data1 'select 1';
>>ERROR:  Failed to get pooled connections
>>
>>postgres=# execute direct on data2 'select 1';
>>ERROR:  Failed to get pooled connections
>>
>>I am pretty sure that I have configured something incorrectly but
>>unfortunately I don't have the experience with this product to make it
>>viable for our project. I can only guess that the problem might lie in
>>the
>>postgresql.conf files on the datanodes but my track record in assumptions
>>is abysmal. Before I throw in the towel though I wonder if I might impose
>>on you to do a quick scan of the attached datanode postgresql.conf files
>>and see if anything jumps off the page to you. I have postfixed the
>>datanode names for each file so you can distinguish them.
>>
>>Thanks for your patience,
>>
>>Bill West
>>
>>
>>
>>
>>
>>On 8/20/13 6:05 PM, "Michael Paquier" <mic...@gm...> wrote:
>>
>>>(Re-adding pgxc-hackers in cc...)
>>>
>>>On Wed, Aug 21, 2013 at 9:38 AM, West, William <ww...@uc...> wrote:
>>>> This is the result from datanode data1:
>>>>
>>>> postgres'# execute direct on data2 'select clock_timestamp()';
>>>
>>>Datanodes are not able to connect between each other, please connect
>>>to a Coordinator and run the following:
>>>execute direct on data2 'select 1';
>>>execute direct on data1 'select 1';
>>>>
>>>> It returned no result.
>>>>
>>>> On datanode data2 this was the output:
>>>>
>>>> postgres=# execute direct on data1 'select clock_timestamp()';
>>>> ERROR:  Failed to get pooled connections
>>>This is the origin of your problem. You cannot connect to Datanode 1.
>>>-- 
>>>Michael
>>
>