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

[Mason S. <ma...@st...>]

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