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?
|
