Re: [Postgres-xc-developers] Installation Guide

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

Thanks Michael,

The value for coord1 is: pgxc_node_name = 'coord1' and for coord2 it is:
pgxc_node_name = 'coord2'

When I run the function to reload the pool I get the following results on
both nodes:

postgres=# SELECT pgxc_pool_reload();
 pgxc_pool_reload 
------------------
 t
(1 row)

Here are the nodes setup in each VM database:


VM1:

postgres=# select * from pgxc_node;
 node_name | node_type | node_port |     node_host      | nodeis_primary |
nodeis_preferred |   node_id
-----------+-----------+-----------+--------------------+----------------+-
-----------------+-------------
 coord1    | C         |      5432 | localhost          | f              |
f                |  1885696643
 coord2    | C         |      5432 | bigonc-db.sdsc.edu | f              |
f                | -1197102633
 data1     | D         |     15432 | localhost          | t              |
t                | -1008673296
 data2     | D         |     15432 | bigonc-db.sdsc.edu | f              |
t                | -1370618993
(4 rows)



VM2:

 node_name | node_type | node_port |    node_host    | nodeis_primary |
nodeis_preferred |   node_id
-----------+-----------+-----------+-----------------+----------------+----
--------------+-------------
 coord2    | C         |      5432 | localhost       | f              | f
              | -1197102633
 coord1    | C         |      5432 | bigonc.sdsc.edu | f              | f
              |  1885696643
 data2     | D         |     15432 | localhost       | f              | t
              | -1370618993
 data1     | D         |     15432 | bigonc.sdsc.edu | t              | t
              | -1008673296
(4 rows)

However I still get the following error using the CREATE TABLE statement:


ERROR: Failed to get pooled connections
SQL state: 53000



Do you have any other ideas on which configuration might be incorrect? Is
there any setting for pooled connections I might have missed (I didn't see
this in the documentation but I am thinking there is something set
incorrectly regarding this)

Thanks again,

Bill West






On 8/19/13 6:28 PM, "Michael Paquier" <mic...@gm...> wrote:

>On Tue, Aug 20, 2013 at 9:17 AM, West, William <ww...@uc...> wrote:
>> ERROR:  Failed to get pooled connections
>>
>> Queries and CREATE NODE DML statements work fine.
>>
>> The configuration looks like this VM 1 = 1 GTM, 1 Coordinator, 1
>>DataNode
>> (Primary, Preferred) - VM 2 = 1 Coordinator, 1 Datanode (Preferred).
>> Does this error indicate any configuration setting that might be off?
>Check that the content on pgxc_node is correct on each Coordinator and
>be sure to have run SELECT pgxc_pool_reload() on each Coordinator.
>
>Regards,
>-- 
>Michael