Re: [Postgres-xc-developers] Installation Guide

[Michael P. <mic...@gm...>]

On Wed, Aug 21, 2013 at 2:09 AM, West, William <ww...@uc...> wrote:
> 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)
OK. Can you run EXECUTE DIRECT when connecting on a Coordinator to a
remote node?
http://postgres-xc.sourceforge.net/docs/1_1/sql-executedirect.html
(Take care grammar has changed a bit between 1.0 and 1.1 to fit with
support of ALTER TABLE for data redistribution).

With your problem you shouldn't be able to connect to them, so there
are two possibilities:
1) Did you set up pg_hba.conf to allow connections from remote nodes?
2) Disable firewalls and retry, connections might be stopped because of that.

Regards,
-- 
Michael