[Postgres-xc-general] failed to get pooled connection issues

[Sandeep G. <gup...@gm...>]

Hi,


 Setup has two computers. The configuration for gtm, gtm_proxy, datanode,
and, coordinator all have listen_address='*'.


Here are the info about setup:
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
 datanode_c1_d1 | D         |     45421 | sfx057    | f              |
f                | -1199687708
 datanode_c2_d1 | D         |     45421 | sfx050    | f              |
f                |  -294121722
(3 rows)


select pgxc_pool_reload();
 pgxc_pool_reload
------------------
 t
(1 row)

However, when I create a table I get

ERROR:  Failed to get pooled connections

Is there anything else apart from listen_address that I am missing?
Please let me know.


-Sandeep