I'm starting to test BDR, and I've followed the quickstart included in the documentation successfully.
The problem I'm encountering is when two servers are on different hosts, which is not covered in the documentation. Node1 is 10.0.0.1, node2 is 10.0.0.2, but when I try to connect from node2:
demo=# SELECT bdr.bdr_group_join(
local_node_name := 'node2',
node_external_dsn := 'port=5432 dbname=demo',
join_using_dsn := 'port=5432 dbname=demo host=10.0.0.1'
ERROR: node identity for node_external_dsn does not match current node when connecting back via remote
DETAIL: The dsn '' connects to a node with identity (6140654556124456820,1,16385) but the local node is (6140654709151998583,1,16385)
HINT: The 'node_external_dsn' parameter must refer to the node you're running this function from, from the perspective of the node pointed to by join_using_dsn
If I add node2 host entry:
demo=# SELECT bdr.bdr_group_join(
local_node_name := 'node2',
node_external_dsn := 'port=5432 dbname=demo host=10.0.0.2',
join_using_dsn := 'port=5432 dbname=demo host=10.0.0.1'
);
FATAL: could not connect to the server in non-replication mode: could not connect to server: Connection refused
Is the server running on host "10.0.0.2" and accepting
TCP/IP connections on port 5432?
DETAIL: dsn was: port=5432 dbname=demo host=10.0.0.2 fallback_application_name='bdr (6140654709151998583,1,16385,):bdrnodeinfo'
justgive=# select bdr.bdr_version();
bdr_version
--------------------------
0.9.0-2015-03-24-f36ee65
(1 row)
Does anybody happen to have any examples of calling bdr.bdr_group_join when there are remote IPs involved?
- Billy