[Postgres-xc-developers] ERROR: No Datanode defined in cluster

[Adam D. <ada...@gm...>]

Hi!

I have got two machines:

Machine 1:
coord1
datanode1

Machine2:
coord2
datanode2

I ma using pgpool to load balance connections between coordinators.
I would like to configure coord1 to see datanode1 and datanode2
and coord2 to see datanode1 and datanode2

This is what I did:

Coordinator 1:

./psql -p 20011 -h 192.168.0.195 postgres

CREATE NODE data_node1 WITH (TYPE = 'datanode', HOST = '192.168.0.195',
PORT = 20012);

CREATE NODE data_coord2 WITH (TYPE = 'coordinator', HOST = '192.168.0.196',
PORT = 20011);

Coordinator 2:

./psql -p 20011 -h 192.168.0.196 postgres

CREATE NODE data_node2 WITH (TYPE = 'datanode', HOST = '192.168.0.196',
PORT = 20012);

CREATE NODE data_coord1 WITH (TYPE = 'coordinator', HOST = '192.168.0.195',
PORT = 20011);


No I would like to create user and db:

CREATE USER user WITH PASSWORD 'password';

CREATE DATABASE test OWNER user;


But I am having error:

ERROR:  No Datanode defined in cluster
HINT:  You need to define at least 1 Datanode with CREATE NODE.


Am I doing something wrong here?