#317 Failed to get pooled connections

[dnt]

Hi there,

I'm hoping you can point where my problem on my configuration. I know the problem is not iptables, hosts.allow or hosts.deny. Right now the iptables is off.
When I connected to the coordinator host and try to create the database I got this error.

postgres=# create database test;
ERROR: Failed to get pooled connections
postgres=#

[dnt]

here are my configuration files my datanode, coord, and gtm conf files

[Michael Paquier]

I am sure that you didn't set up your Coordinator with remote nore connection information.
Try to have a look at this documentation page:
http://postgres-xc.sourceforge.net/docs/1_0/install-short.html

First check the content of catalog pgxc_node, containing all the connection information stored on your local node. If it contains only one line, being the Coordinator node you are connected to, you need to define the connection information to your remote nodes.

In order to do that use the queries CREATE/ALTER/DROP NODE and then run "SELECT pgxc_pool_reload();"

If the problem still persists, perhaps you did not set listen_addresses on each node or you did not use the option "-i" to allow tcp-ip connections to your remote nodes.

[Michael Paquier]

This is definitely a configuration mistake, and not a bug.
So closing it now.
If there are any additional questions, you should contact postgres-xc-developers at lists.sourceforge.net.