[Postgres-xc-general] createdb: database creation failed: ERROR: Failed to get pooled connections

[Neil M. <nm...@xu...>]

Can anyone point out where I am going wrong here ?

Here is a complete log of what i've done to setup , error at the end:

Data/Coordinator machines:
==========================

node1:
======

rm -fr /opt/postgres/data*

mkdir -p /opt/postgres/data_coordinator1
mkdir -p /opt/postgres/data_datanode1

chown postgres: /opt/postgres/data_*

su - postgres

initdb -D /opt/postgres/data_coordinator1 --nodename coordinator1
initdb -D /opt/postgres/data_datanode1 --nodename datanode1

#configure /opt/postgres/data_coordinator1/postgres.conf with GTM server
#configure /opt/postgres/data_datanode1/postgres.conf with GTM server


postgres -X -p 15432 -D /opt/postgres/data_datanode1 >>logfile 2>&1 &
postgres -C -D /opt/postgres/data_coordinator1 >>logfile 2>&1 &

node2:
======

rm -fr /opt/postgres/data*

mkdir -p /opt/postgres/data_coordinator2
mkdir -p /opt/postgres/data_datanode2

chown postgres: /opt/postgres/data_*

su - postgres

initdb -D /opt/postgres/data_coordinator2 --nodename coordinator2
initdb -D /opt/postgres/data_datanode2 --nodename datanode2

#configure /opt/postgres/data_coordinator2/postgres.conf with GTM server
#configure /opt/postgres/data_datanode2/postgres.conf with GTM server

postgres -X -p 15433 -D /opt/postgres/data_datanode2 >>logfile 2>&1 &
postgres -C -D /opt/postgres/data_coordinator2 >>logfile 2>&1 &

each coordinator node:
======================

postgres -C -D /opt/postgres/data_coordinator1 >>logfile 2>&1 &


tail -f log	

GTM machine:
=============

rm -fr /opt/postgres/data*

mkdir -p /opt/postgres/data_gtm

chown postgres: /opt/postgres/data*

su - postgres

initgtm -D /opt/postgres/data_gtm -Z gtm
gtm -D /opt/postgres/data_gtm >logfile 2>&1 &

Registering Nodes: (all datanodes ??? has been done on both, output below)
==================

psql -c "CREATE NODE datanode1 WITH (TYPE = 'datanode', PORT = 15432)" postgres
psql -c "CREATE NODE datanode2 WITH (TYPE = 'datanode', PORT = 15433)" postgres
psql -c "SELECT pgxc_pool_reload()" postgres
select oid,node_name from pgxc_node;

#output 

node1:
postgres=# select oid,node_name from pgxc_node;
  oid  |  node_name   
-------+--------------
 11129 | coordinator1
 16384 | datanode1
 16385 | datanode2
(3 rows)


node2:
[postgres@las1-app015 ~]$ psql -c "select oid,node_name from pgxc_node;" postgres
  oid  |  node_name   
-------+--------------
 11129 | coordinator2
 16384 | datanode1
 16385 | datanode2
(3 rows)




Creating DB's :
===============

[postgres@las1-app014 ~]$ createdb test
createdb: database creation failed: ERROR:  Failed to get pooled connections