[Postgres-xc-developers] FW: Installation Guide

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

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
>