On Thu, Oct 3, 2013 at 1:34 PM, Sandeep Gupta <gup...@gm...>wrote:
> 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
>
Please check if you have a firewall running and open up the necessary ports.
Also, edit pg_hba.conf to allow connections from the coordinator to the
data nodes.
>
> Is there anything else apart from listen_address that I am missing?
> Please let me know.
>
>
> -Sandeep
>
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>
>
--
Mason Sharp
StormDB - http://www.stormdb.com
The Database Cloud
Postgres-XC Support and Services
|
